Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to convert total hours (HH:MM) into decimal number
How can I convert total time (HH:MM) into a decimal (HH.MM)
Where 30 minutes (xx:30) equals .50. So far I have the formula =(INT(VALUE(O16))*24)+(HOUR(VALUE(O16)))+((MINUTE( VALUE(O16))/100)) but still need to convert minutes to decimal |
#2
|
|||
|
|||
With time in A1 (10:30 for example)
=A1*24 will yield 10.5 Note that time is already in decimal format in XL. The format option displays the time as hours, minutes and seconds. "Greg T" <Greg wrote in message ... How can I convert total time (HH:MM) into a decimal (HH.MM) Where 30 minutes (xx:30) equals .50. So far I have the formula =(INT(VALUE(O16))*24)+(HOUR(VALUE(O16)))+((MINUTE( VALUE(O16))/100)) but still need to convert minutes to decimal |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
Convert week number into calendar month? | Excel Worksheet Functions | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |