Roster Planner

Trebor8484

Board Regular
Joined
Oct 27, 2018
Messages
57
Hi,

Hoping someone may be able to assist please.

I have a workbook with 3 tabs:

Working Hours which is a list of employee ID's, dates, start and finish times and total hours worked.

Roster which is the shift pattern for each employee ID, i.e. Monday to Friday or Friday to Tuesday.

The third tab called Planner is where I am struggling. I am trying to find for each day whether someone has missed a shift. So it needs to cross reference the Working Hours tab initially to see if the employee was due on shift which is indicated with a Y/N (I was trying to use the Weekday function to cross check this). If the employee was due on shift, then it needs to cross reference the Working Hours tab so see if they have worked for that day. Anything that has a roster of Y and zero working hours needs to flag as a missed shift.

There may be instances where a resource has worked an alternate day outside of their usual shift pattern but for this exercise I need to completely ignore those and only flag missing shifts.
 

Attachments

  • Capture1.JPG
    Capture1.JPG
    88.6 KB · Views: 7
  • Capture2.JPG
    Capture2.JPG
    63.6 KB · Views: 6
  • Capture3.JPG
    Capture3.JPG
    77.6 KB · Views: 7

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,127,345
Messages
5,624,127
Members
416,012
Latest member
rockermom59

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top