date-time

I thought I was pretty good at managing Date formats in Excel but this one has left me stumped. The raw data field in the csv pre import is in the USA format and complicated by being AM/PM too. ,"8/30/2021 7:39:07 AM", ,"8/29/2021 11:28:40 PM", All other columns are simple numeric or text How...

I have American date-time data, such as the following: 02/01/2019 13:00:00 which is 1pm, 1st February 2019. Can anyone help with a formula to extract only the date element in UK format? Thanks.

Hi! I've a problem in DAX I can't solve. Perhaps you could help me... In an stock movement table, i have the next columns: Date-time, Product id, Movement id, Order id and Stock. The final stock value for each product is the number that appears in the column "Stock" in the last date-time and...

Hello, I have a column of cells with the following text format, "2:03pm September 27th – 3:12pm September 27th". I want to extract the two date-time combinations into separate columns in Excel date-time format to enable further processing (e.g. to calculate duration of the event and to sort...

I have a report that outputs date-time stamps in the following format: July 13th 2017, 11:40:21.553, and need to extract Day, Month, Year and Time in separate columns and then recombine them to create a valid date-time stamp. Please help! Sample below illustrates the consistency of the strings...

Hello, firstly let me say i am a complete newbie to posting in forums although i have used them often to point me in the right direction. I Have an excel 2007 table that gets updated every time a user adds or amends a record in a database even if they only press save. i need to count the...