Hi Good Day,
Need badly your help on this.
Input CSV file with amazing date format :( , please see attached image for info.
Input data :
54:34.0 |
Expected Output : 2024-02-02 10:00
@kathbanc: take a look at this link
https://stackoverflow.com/questions/65140584/convert-date-column-formated-as-xxxx-x
It appears that the data you have provided thus far is a series of minute, second, and millisecond values instead of a full time or date. Said differently, 54:34.0 could be 11:54:34 AM, it can be 12:54:34 PM, etc. It'll be difficult to create formula syntax to get the conversions to work without having a working sample of data from this...amazingly formatted...CSV file ;)
All kidding aside, if you can provide some additional data of what we are working with, then I think I can help you out on this one.