Finding Average Time Excluding Zero

[JoeH7745]

I have a worksheet where i have a start and finish date and time in separate columns. I have another column that has a formula to give me the time in hours and minutes it took from start to finish. I need to average the completion time of the column W3:W412 and exclude the 0:00 times for the cells in the column that do not have data yet. I get a #DIVO/0! error each way I try it.

 

[DanteAmor]

It is not necessary for these formulas to be entered with Control + Shift + Enter, try and let me know.

=IFERROR(AVERAGEIF(W3:W412,"<>0",W3:W412),0)
=IFERROR(AVERAGEIF(X3:X412,"<>0",X3:X412),0)

 

[DanteAmor]

I figured it out! I had a mistake in the cells counting time which threw off the average formula!

Please note: In the future, when you mark a post as a solution, please mark the post that contains the solution, not your own post unless your post contains the solution.