Computing.Net > Forums > Office Software > Convert an odd format to Excel Time

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Convert an odd format to Excel Time

Reply to Message Icon

Name: Edoga
Date: January 6, 2009 at 13:25:29 Pacific
OS: VMWare Fusion - WinXP with Office 2007
CPU/Ram: 2.0Ghz Core2Duo - 2GB DDR3
Product: Apple MACBOOK
Subcategory: Microsoft Office
Comment:

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 ?



Sponsored Link
Ads by Google

Response Number 1
Name: jon_k
Date: January 7, 2009 at 06:01:40 Pacific
Reply:

easy way is to convert the data:

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

Then just format it as required.


0

Response Number 2
Name: Edoga
Date: January 7, 2009 at 09:34:11 Pacific
Reply:

That worked perfectly. Thank you Jon!


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Convert an odd format to Excel Time

Quattro to Excel w/o losing formula www.computing.net/answers/office/quattro-to-excel-wo-losing-formula/7048.html

Converting Lotus 123 files to Excel www.computing.net/answers/office/converting-lotus-123-files-to-excel/1009.html

Convert Lotus Approach 97 to Excel www.computing.net/answers/office/convert-lotus-approach-97-to-excel/4075.html