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

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History