| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate negative or positve difference in time
I make two manual entries of average times to compare last year with this
year. I need to calculate the difference between the two times (it could be an increase or decrease), and show both the difference (+ or -) in hours and minutes, and the % of change (+ or -) from last year to this year. Example: 2:03 average talk time last year, 3:50 average talk time this year = increase of 1:47 (1 min. 47 sec.). or 86.99 % increase in talk time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I replace a negative number at the end of a formula with a. | Excel Discussion (Misc queries) | |||
| Calculating time difference | Excel Discussion (Misc queries) | |||
| How do you calculate the difference between two values within a p. | Excel Discussion (Misc queries) | |||
| What is the formula for getting time difference e.g. ("4 hrs 15 m. | Charts and Charting in Excel | |||
Threaded Mode
