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

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