Convert an odd format to Excel Time

Apple MACBOOK
January 6, 2009 at 13:25:29
Specs: VMWare Fusion - WinXP with Office 2007, 2.0Ghz Core2Duo - 2GB DDR3
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.840

Can anyone think of a formula to solve this ?


See More: Convert an odd format to Excel Time

Report •


#1
January 7, 2009 at 06:01:40
easy way is to convert the data:

=value(A1)/(24*60*60*1000)

Then just format it as required.


Report •

#2
January 7, 2009 at 09:34:11
That worked perfectly. Thank you Jon!

Report •

Related Solutions


Ask Question