| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I use a time difference in a subsequent formula in Excel?
When subtracting two dates/times from each other, Excel stores the result as
a number different from the displayed result (e.g., displayed result = 2.42 hours but stored number = 0.1125.) How can I effectively use the displayed result in a subsequent formula rather than the stored number? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate time difference to the half hour | Excel Worksheet Functions | |||
| Time zone Time difference | Excel Worksheet Functions | |||
| calculate difference in time to hours | Excel Worksheet Functions | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
| Time / Formula to look at time difference | Excel Worksheet Functions | |||
Threaded Mode
