| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal time | Excel Worksheet Functions | |||
| Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
| Decimal Time | Excel Worksheet Functions | |||
| If Statement - in time not decimal minutes | Excel Worksheet Functions | |||
| elapsed time | Excel Worksheet Functions | |||
Linear Mode
