Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-13-2011, 10:45 AM
jhwtsang jhwtsang is offline Converting decimal to hours Windows XP Converting decimal to hours Office 2007
Novice
Converting decimal to hours
 
Join Date: May 2011
Posts: 3
jhwtsang is on a distinguished road
Default Converting decimal to hours

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,
Reply With Quote
  #2  
Old 05-13-2011, 02:10 PM
macropod's Avatar
macropod macropod is offline Converting decimal to hours Windows 7 32bit Converting decimal to hours Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,496
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

What does the 1905.3 represent - hours, minutes days? I can't see any time-based relationship between that and 266:19:00.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-13-2011, 02:38 PM
jhwtsang jhwtsang is offline Converting decimal to hours Windows XP Converting decimal to hours Office 2007
Novice
Converting decimal to hours
 
Join Date: May 2011
Posts: 3
jhwtsang is on a distinguished road
Default

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

Thanks for the reply.
Reply With Quote
  #4  
Old 05-13-2011, 04:12 PM
macropod's Avatar
macropod macropod is offline Converting decimal to hours Windows 7 32bit Converting decimal to hours Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,496
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-16-2011, 01:36 PM
jhwtsang jhwtsang is offline Converting decimal to hours Windows XP Converting decimal to hours Office 2007
Novice
Converting decimal to hours
 
Join Date: May 2011
Posts: 3
jhwtsang is on a distinguished road
Default

Thanks, it worked!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help on the formulate hours meninio Excel 2 02-11-2011 04:56 AM
Decimal tabs with space as thousands separator harry Word 0 10-05-2010 03:22 PM
Converting decimal to hours Excel convert format [h]:mm:ss to decimal gchan2000 Excel 1 08-17-2010 01:36 PM
Converting decimal to hours 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 04:07 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft