![]() |
|
#1
|
||||
|
||||
![]()
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] |
#2
|
|||
|
|||
![]()
Ok, so when I do that is the answer i am seeing (2291.07) in hours? Is there a way to change that to days, hours and minutes without getting a wrong answer?
Head completly wrecked over this! Thanks. |
#3
|
|||
|
|||
![]()
Hi,
I found a solution on another website using the A2-A1 formula and custom formating the answer as [h]:mm I was able to get my answer in hours and minutes format. ![]() The formula I found to change the sum total of hours and mins to days, hours and mins was (assuming my answer was in cell A25) =INT(A25) &" Days" & INT(MOD(A25,INT(A25))*24) &" Hours and " & MINUTE(A25) & "Minutes" So with this in mind, is there a way to further change this answer to Months, days, hours and minutes or am I trying to do the impossible with Excel?! ![]() Thanks. |
![]() |
|
![]() |
||||
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 |