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.