Finding Average Time Excluding Zero

JoeH7745

New Member
Joined
Feb 13, 2025
Messages
9
Office Version
  1. 365
Platform
  1. Windows
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.
 

Attachments

  • Screenshot.jpg
    Screenshot.jpg
    151.7 KB · Views: 8
It is not necessary for these formulas to be entered with Control + Shift + Enter, try and let me know.

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

😇
 
Upvote 0
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.

:giggle:
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,926
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top