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!

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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