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]

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.

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.