elapsed time displayed as a decimal
 

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.

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


--
Regards,
Dave


"CH" wrote:

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.