Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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.

share|improve this question

migrated from superuser.com May 3 '13 at 17:51

This question came from our site for computer enthusiasts and power users.

What format (the "123" toolbar icon) are the cells set to, and what does "not coming out correctly" mean? If you create a spreadsheet, putt 04:30 and 03:30 in cells A1 and A2, and =AVERAGE(A1,A2) in A3, what do you get and what do you expect to get? –  Gabe May 3 '13 at 15:14

1 Answer 1

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)

enter image description here

For time Elapsed use simple subtraction = Cell B - Cell A

enter image description here

share|improve this answer
I apologize, I want the elapsed amount of time to show in C1. So the clock starts in A1 and stops in B1. I did format the cells. –  flipnija513 May 3 '13 at 16:17
That's not an average, that's simple subtraction. –  Al E. May 3 '13 at 17:49
Your question says Average. If you want the Elapsed time just subtract. –  Buscar웃 May 3 '13 at 18:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.