Mean time between dates. Multiple columns.

[engine_man3]

I'm sure this is a simple solution, but I can't seem to wrap my brain around the easiest way to do this.

I need to know the time passed between the start (date and time) and the finish (date and time). Keep in mind, sometimes the time goes over multiple days, so the date must be factored in.

 

[AD_Taylor]

Something like this in Column N copied down

=TEXT( (M2-K2) + (L2-J2), "[hh]:mm:ss")

 

[Andrew Poulsom]

Or just:

=SUM(L2:M2)-SUM(J2:K2)

formatted as [hh]:mm:ss

 

[CodeNinja]

Use the formula:
=L2-J2+M2-K2

Then format the column/cells with that formula to custom format of: [h]:mm:ss

To custom format, highlight the cells then hit CTRL & 1 then put in the above formula in the type text box.

 

[nuked]

Something like this:

=DAY(L1-J1) & " Day(s) " & HOUR(M1-K1) & " Hour(s) " & MINUTE(M1-K1) & " Minute(s)"


or to overkill it further...

=DAY(L1-J1) & " Day(s) " & HOUR(M1-K1) & " Hour(s) " & MINUTE(M1-K1) & " Minute(s) " & SECOND(M1-K1) & " Second(s)"

 

[engine_man3]

Or just:

=SUM(L2:M2)-SUM(J2:K2)

formatted as [hh]:mm:ss

This is what I went with. For some reason I didn't think it would carry time over dates. Thanks to all for your help