![]() |
#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] |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
dglazer | Excel | 2 | 07-28-2015 01:42 AM |
![]() |
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 |
![]() |
alysolyman | Excel | 6 | 05-13-2013 02:19 AM |
![]() |
Snvlsfoal | Word Tables | 1 | 08-11-2011 05:42 AM |