Forum Discussion
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 includes minutes to deduct from the Elapsed time.
Column G contains no data.
Column J contains cells with this formula to calculate the Elapsed Time:
=IF(I16=E16,I16-E16-F16-H16,I16-F16-H16+1-E16)
=IF(I17=E17,I17-E17-F17-H17,I17-F17-H17+1-E17)
=IF(I18=E18,I18-E18-F18-H18,I18-F18-H18+1-E18)
How can I calculate the average of the elapsed times in Column J?
You may simplify a bit using formulae as
Average returns correct results, please open attached. Perhaps you may share sample file?
6 Replies
=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?
