Average if with TIME

[Sparda142]

Hello,

While using the following formula i receive "#DIV0!" for the time stamp of 8:00 AM, what can i do to get the proper average in the column AA format

=AVERAGEIFS($AA$3:$AA$40929,$Z$3:$Z$40929,$AC3,$AB$3:$AB$40929,AD$2)


[TABLE="width: 779"]
<tbody>[TR]
[TD="colspan: 4"]Y------------z-----------AA---------AB------AC-------AD---------AE---------AF---------AG------AH---------AI--------AJ

[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 779"]
<colgroup><col><col span="11"></colgroup><tbody>[TR]
[TD="colspan: 4"] [/TD]
[TD][/TD]
[TD]Monday[/TD]
[TD]Tuesday[/TD]
[TD]Wednesday[/TD]
[TD]Thursday[/TD]
[TD]Friday[/TD]
[TD]Saturday[/TD]
[TD]Sunday[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Interval[/TD]
[TD]Out AHT Hour[/TD]
[TD]weekday[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]00:00:32[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]00:01:44[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8:15 AM[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]00:00:14[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8:30 AM[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
[TR]
[TD="align: right"]1/2/2018[/TD]
[TD="align: right"]8:00 AM[/TD]
[TD="align: right"]00:02:31[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8:45 AM[/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[TD="align: center"]#DIV/0![/TD]
[/TR]
</tbody>[/TABLE]

 

[Sparda142]

figured it out

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1081907-average-if-error.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).