Thread: [Solved] Converting decimal to hours
View Single Post
 
Old 05-13-2011, 10:45 AM
jhwtsang jhwtsang is offline Windows XP Office 2007
Novice
  
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