How to distribute/breakdown items into 15-min interval

[marvhielnx]

Hello,

I'm new to this forum and new to vba. I'm not sure how i can automate it, but i hope someone can help me. I have a pivot with time period (min and max) and count of status per period. The desired output is for the sum of count per period to be distributed in 15-min interval from min to max.

Pivot
Period Active Email Break Lunch Inactive
02:00 - 03:45 28 1
02:00 - 04:00 6
02:00 - 04:15 15
03:45 - 04:00 28 1


Output
Interval Active Email Break Lunch Inactive
2:00 AM 49 (28+6+15) 0 0 0 1
2:15 AM 49 (28+6+15) 0 0 0 1
2:30 AM 49 (28+6+15) 0 0 0 1
2:45 AM 49 (28+6+15) 0 0 0 1
3:00 AM 49 (28+6+15) 0 0 0 1
3:15 AM 49 (28+6+15) 0 0 0 1
3:30 AM 49 (28+6+15) 0 0 0 1
3:45 AM 21 (6+15) 0 28 0 1
4:00 AM 15 (15) 0 0 0 0


Appreciate all the help I can get
Thanks!

[marvhielnx]

Apologies, the table is distorted. I have attached the file for easier viewing.