elapsed time displayed as a decimal

[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.

[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


--
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.