![]() |
|
#4
|
||||
|
||||
|
Where the differences are up to 31 days, you can use simple subtraction and average, with a custom number format like:
d" days, "h" hours & "m" minutes" For anything more than a month, you'd probably do best to work with a simply numeric format that expresses the output in decimal days, rather than trying to get it to do days, hours & minutes.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Trouble with absolute values and hours/minutes and formulas
|
dglazer | Excel | 2 | 07-28-2015 01:42 AM |
Need a formula to calculate turnaround time in hours
|
ram_cl1981 | Excel | 5 | 09-29-2014 02:20 PM |
| How to transform hours into minutes in mail merge | ppochelon | Mail Merge | 1 | 09-29-2013 07:07 PM |
Calculate difference by days and hours
|
alysolyman | Excel | 6 | 05-13-2013 02:19 AM |
Calculate elapsed time in Word table?
|
Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |