Formula to calculate the total time between two seperate dates

Hi DebbieF,

Assume your opened date in Cell A1 and closed date in Cell B1

Then in cell C1 = B1-A1 "format this cell to Custom [hh]:mm"

Hope it works..

Thanks

I've tried that but it only works out the time and does'n't take into consideration there are several days in between. So if for example the open time shows as 11.00am and the closed time shows as 13.00pm it shows the total time as 2 hours and doesn't take into consideration the fact that the open time was on the 7th June and the closed time on the 9th June

Use C1 = (B1-A1)*1440, this would show the difference in minutes

assume your old date in A1 & new date/time in A2

=DATEDIF($A$1,B1,"d")&" Days & "&TEXT(B1-A1,"h:mm")&" Min"

Thanks Sadath31 that is working to an extent but it shows the result as 1 day and 2:23min. I need it to show the result as 26:23min. How do I do that?

then you should go for the formula given by Navas or =TEXT(B1-A1,"[hh]:mm")

Thanks it is working to an extent that at least now it shows the result as 2days2:00. Is there anway to covert this so that it shows as 50:00?

Figures it out thanks for all the help