How to convert date format from 00:00.0 to an understandable one?

[Thien Dao]

Hi everyone,

I've just received a dataset with the following date format:

creationdate	submissiondate
11:34.6	11:34.6
22:43.3	22:43.3
22:44.6	22:44.6
28:38.2	28:38.2

Can you help me to convert it to an understandable format?

Thanks,

[William Lisowski]

I guess the first step is to understand what those numbers represent. What could 28:38.2 possibly represent? It looks like minutes (e.g.28) and seconds within the minute (e.g. 38.2), but that's not what I think of as a "date", not even what I think of as a "time".

So to advise you on converting it to something understandable, you're going to have to help up understand the numbers as they are.

[Thien Dao]

Thanks William for your suggestion.
I will need to contact the source of data for this matter.