EXCEL TIME

[georgereni]

How can I convert this data into a total hours format instead of date and time

This data should represent three thousand three hours, fifty two minutes and four seconds.

3303:52:04

Instead it show in excel as 5/16/1900 3:52:04 PM

How can I change it to total hours and not time????

 

[SkipVought]

hi,

Format the cell - custom "[h]:mm:ss"

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[SkipVought]

BTW,

The actual VALUE that Excel CONVERTS the TIME STRING, "3303:52:04" to is 137.6611574, which as a Date/Time value is 5/16/1900 15:52:04

Just be aware that the actual value is 137.6611574 days.

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244