elapsed time displayed as a decimal

G

Guest

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

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate elapsed time excluding specific timeframe 10
Calculating Elapsed Time 2
Formula for elapsed time 3
calculate elapsed time between dates and times 2
Calculate Elapsed time: difference between 2 Date/Timestamp perio 4
Converting Hours:Minutes to Decimal 2
Time elapsed calculation 6
Access Access - Elapsed Time between Records 5

Top