In columns K and L I have time stamps.
Let's say 03:30 is in column K and 04:30 is in column L.
I want the total elapsed amount of time in hh:mm in column P.
I have tried the average function, but it's not coming out correctly.
migrated from superuser.com May 3 '13 at 17:51
This question came from our site for computer enthusiasts and power users.
For times that span past midnight you cannot simply subtract. Or you'll get a negative number.
What you'll want to do (where start is column A and End is column B, etc.) is the following formula:
The one being equal to twenty-four hours. So: 9 pm to 5:38 am = 8:38.
Do you mean output like this!
Cell C1 shows correct averages.
If yes, set the cell format to 24 hours and use the Average for (Numbers)
For time Elapsed use simple subtraction = Cell B - Cell A