|Still can't figure this one out myself . . Any help would really be appreciated !|
My spreadsheet of exported 'time values' looks like this (Text type)
I'd like all these values to be in Time format and look like hh:mm:ss.00 for example 59600 would be 59.600 (seconds and milliseconds)
63840 would need to look like 1:03.840
Can anyone think of a formula to solve this ?