Converting decimal to hours

jhwtsang · #1 05-13-2011, 10:45 AM

Hi all,

I need for help! I'm trying to convert a time, currently displayed as decimals (ie. 1905.3), into hours that looks like 266:19:00.

When I try to use the [h]:mm:ss custom format, 1905.3 becomes 45727:12:00 for some reason.

Please help!
Thanks,

macropod · #2 05-13-2011, 02:10 PM

What does the 1905.3 represent - hours, minutes days? I can't see any time-based relationship between that and 266:19:00.

jhwtsang · #3 05-13-2011, 02:38 PM

1905.3 being 1905 hours and 20 minutes.
266:19:00 being 266 hours, 19 minutes and 0 seconds.

Thanks for the reply.

macropod · #4 05-13-2011, 04:12 PM

For values like 1905.3, you need to divide the number by 24, then format the cell as [hh]:mm:ss. This will return 1905:18:00 (which is the correct result).

jhwtsang · #5 05-16-2011, 01:36 PM

Thanks, it worked!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Decimal tabs with space as thousands separator	harry	Word	1	12-22-2023 02:59 PM
Help on the formulate hours	meninio	Excel	2	02-11-2011 04:56 AM
Excel convert format [h]:mm:ss to decimal	gchan2000	Excel	1	08-17-2010 01:36 PM
Convert hours in decimal	ghostones	Excel	1	12-29-2009 09:17 PM
Merge, Too many Numbers right of the Decimal Point	ohdearme	Mail Merge	0	10-25-2009 05:10 PM