Email volume spread out over 125 min intervals

Topic Views - 344

Email volume spread out over 125 min intervals
I have a CSI spread sheet that requires data be entered in 15 minute intervals. I have data based on day, week, month. How do I calculate the volume over 8hours using 15 min intervals? For instance I have 80 emails on mon, 112 on Tue, 65 on Wed ect. How do I break those down to 15min intervals each day.

Email volume spread out over 125 min intervals
Good morning Pamela,
I hope I understand your question the right way. If not, I apologize first.
Each hour has four 15 minute intervals, every shift 8 hours i.e. 32 intervals. In this case you divide 80/32 for Monday, 112/32 for Tuesday, 65/32 for Wednesday etc.
For the whole week you count the email volume from Mon-Fri (80+112+65+) and divide it through 32 (intervals per shift) x 5 (days per week).
(Mon+Tue+Wed+Thu+Fri) / (32 Intervals x 5 days)

A.e. (80+112+65+82+44) / (32 x 5) = 2,39375 Emails per 15 minute interval in average
Best Regards from Ireland
Walter

Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question