# 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