Time Duration Between Two Dates and Times

[marvin jones]

Hi,

What formula would i use in D2 to get the correct days, hours and minutes duration between cells A2 and A3?

A2 01/09/2019 19:07:30 PM D2 Formula to state 1 Day 11 Hours and 18 Minutes
A3 02/09/2019 16:10:50 PM

Thanks.

 

[marvin jones]

Ah - This is great Gerald, sorry, i see what you mean now. Really simple too!

I also wanted to a summary of total times, so i presume i can just sum up the hours etc using a simple SUM formula?

 

[Gerald Higgins]

Yes applying a SUM formula to get a total should work.

 

[marvin jones]

Thank you for your help, much appreciated.

 

[marvin jones]

Hi Gerald,

Sorry to bother you again.

In my summary tab i have the below;

D2: 19 days 03 hours 45 minutes
D3: 20 days 22 hours 13 minutes

However, if i SUM this, i get 9 days 01 hours 59 minutes?

Am i doing something wrong?

Thanks.