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