Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time format to number while keeping value | Excel Worksheet Functions | |||
Change over time fornula | Excel Worksheet Functions | |||
" / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions |