I inserted a column (now column C 'Data Log'), removed data validation from it and put this formula in C2 and filled down to combine the hour/minute/seconds.. Then I formatted those [h]:mm:ss. (2:03:12)That is much easier to work with.
After that try array entering this in C2 of 'Lowest Times' and filling down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Do the same in 'Highest Times' and 'Average Times' with these.
Your workbook returns only one time for each. The rest are either 0 or #DIV/0!
Bookmarks