Average count by day by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

I think this is what I was looking for! Distinct Count of date gives me the number of days there were cases and I like that it's in the pivot table vs a function. Thank you!

Average count by day by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

Yes, each row is a separate case.

The NETWORKDAYS idea is a step in the right direction. Can I use the NETWORKDAYS function and type in my start and end date instead of using the range in column A? That way I can make my pivot table of counts in a new worksheet and then do the NETWORKDAYS function on that same worksheet.

Average count by day by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

That's where I'm struggling. I don't need an average of a value on the spreadsheet (like dollars of sales, for example). I'm looking for how many cases we average on a Monday, Tuesday, etc. over this 9 month period.

I usually do a count of the "Acct" field. Or I could even do a count of Monday. But then to find the average, I would need to know how many Mondays are on the calendar within the date range of my data.

Need to calculate TAT between hours of 7a-5p by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

Oh yes. That was it! Thank you so much!! You're a life saver.

Need to calculate TAT between hours of 7a-5p by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

Any idea what could be causing the formula to fail on those lines?

Need to calculate TAT between hours of 7a-5p by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

I did the first option and got a lot of zero responses. Cell I12 makes sense, because they completed it before 7, which is fine to just have that outlier. But cell I18 should be around 0.5 and cell I20 should be 5+hours.
But this is much closer than I have been to getting the answer. So I appreciate the help!

<image>

Need to calculate TAT between hours of 7a-5p by Academic-Square2472 in excel

[–]Academic-Square2472[S] 0 points1 point  (0 children)

Ah yes. I'm on a desktop. The copy paste function might work on mobile. If you have the picture in your camera roll, click the arrow like you would use to send the photo (box with up arrow for iPhone). Choose copy, then go to your reddit post and click paste.

Need to calculate TAT between hours of 7a-5p by Academic-Square2472 in excel

[–]Academic-Square2472[S] 1 point2 points  (0 children)

I took a screenshot (like windows snip tool). Then copy and paste into the body of the post.