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)

...

59600

59960

63840

64000

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

or

63840 would need to look like 1:03.840Can anyone think of a formula to solve this ?

easy way is to convert the data: =value(A1)/(24*60*60*1000)Then just format it as required.

That worked perfectly. Thank you Jon!

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History