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?
Thanks Hans.
=AVERAGE(J16:J18) produces 13:45 on my computer.
The average of the hours is 5:45.
=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?