"Joe User" <joeu2004 wrote in message
...
"mp" wrote:
How to get time difference in hours and fractions of hours?
[....]
Col A Col B Col C
Start Time End Time Elapsed
2:50 PM 3:10 PM = B-A

=(B2-A2)*24

formatted as Number with some number of decimal places.

Time and dates are stored as days and fraction of days.


Thanks much! that works
mark