Average Time Calcuation

I am having issues getting the average time to populate. I need column I to populate the average of all of the times excluding the #VALUE!. The problem I keep running into is I get #DIV/0!.

The DIV/0 error is caused by your times actually being text.
For example in F1 you've got the formula =TEXT(D1-C1,"h:mm"), which by its very nature stores the result as text (clue is in the function name).
You need to coerce the result into a number before you can perform calculations on it. Easily done by multiplying the result by 1. =TEXT(D1-C1,"h:mm")*1

You can also wrap the formulas in IFERROR to prevent the VALUE errors showing up and further confusing things. =IFERROR(TEXT(D1-C1,"h:mm")*1,0)

Hope that helps.

BSB

See the appendix for a simplified solution to your question.