How can I change time format to decimal without losing hours?
I am trying to enter a time of 33:13:00 and get a display of a decimal of
33.21. If I format the box to be decimal when I enter the time it does not give the full 33 hours but in turn replaces it with 1.38. Is there are function or formula that will allow the user to type in the time in hours and minutes to convert it to a decimal format? |
How can I change time format to decimal without losing hours?
If you input time in A1 then in B1 =A1*24 format as number -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=561838 |
How can I change time format to decimal without losing hours?
If a1 = 33:13:00 then in B1 enter =A1*24. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561838 |
All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com