See your other post.

Regards,
Fred

"ijustlivehere" wrote in message
...
What if I go over midnight?

"Peo Sjoblom" wrote:

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?