DATE retrieve on CSV File how to convert

[kathbanc]

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

[rzdodson]

@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.