Forum Discussion
Solved
Average Elapsed Time
Excel 2013. All cells in this spreadsheet are formatted as Time. Column I is the End Time. Column E is the Start Time. Column F includes minutes to deduct from the Elapsed time. Column H inc...
You may simplify a bit using formulae as
Average returns correct results, please open attached. Perhaps you may share sample file?
=AVERAGE(J16:J18)
Adjust the range J16:J18; it does not matter if it includes empty cells.
- Thanks Hans.
=AVERAGE(J16:J18) produces 13:45 on my computer.
The average of the hours is 5:45.You may simplify a bit using formulae as
Average returns correct results, please open attached. Perhaps you may share sample file?
- Thanks so much Sergei. Someone at the Excel Help Forum gave me a similar answer. Your solution is very good. I have not seen the MOD function used with the "-1". How does that work?
