Convert Shift into Hourly Format

swatpro

New member
Joined
Dec 25, 2019
Messages
4
Reaction score
0
Points
0
Excel Version(s)
2016
Hi, I need a help to convert the shift wise data into hourly format.

Please find the attached file and would really appreciate your help.
 

Attachments

  • Convert to Hourly Interval Wise.xlsx
    33.3 KB · Views: 12
There is nothing in the workbook to show what you want. Fill in a few lines of the results table manually to show us.
 
There is data shift wise i just need to distribute it hourly wise.
Example 07:00 - 15:00 Shift is having 2 agents so hourly wise 7 am to 3 pm shift will have 2 count on each interval hourly wise but let say there are 4 agents coming 9am so count will be 6 agents at 9 AM.

It should look something like this, i just cant find a way to apply on all the shift intervals

Capture.JPG
 
Last edited:
Sorry i didn't get you
 
Attach the workbook (not a picture) with the results you want mocked up. I am not going to waste time reproducing the data!
 
Back
Top