Multiply by 24 and format as general or number


=A2*24



--


Regards,


Peo Sjoblom

"3Nails" wrote in message
...
Calculated hours and mintues from time;

16:00 (4PM) to 19:30 (7:30PM) is 3:30.

How can I convert the results 3 hours and 30 minutes to 3.5 hours?