Thread: [Solved] Converting decimal to hours
View Single Post
 
Old 05-13-2011, 04:12 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
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