elapsed time displayed as a decimal

C

CH

How do I calculate elapsed time and return the number of hours expressed in
hours and tenths of an hour. For example 8:00 AM to 10:15 AM is 2.3 elapsed
hours.
 
D

David Billigmeier

Assume your end time is in B1 and your start time is in A1, enter this into
any formula and format it as a number:

=(B1-A1)*24
 
Top