0900-1800

  1. D

    Help with Formula to Count if an Employee will be on a 6 day straight sched or 7 days Straight Sched

    Hi All, Would an expert on this Please. On Cell P3 i wanted to display a text like this "6 Days" or "7 Days" else "5 Days" I have a schedule that looks Like this: (The name of the employee would be on Cell B2) Cell H2 would be Sunday (This would be the Current Week)...
    • dlealb
    • Thread
    • 0800-1700 0900-1800 1000-1900 1100-2000 cell
    • Replies: 1
    • Forum: Excel Questions
  2. A

    Roster spreadsheet using v/h lookup, sumproduct.sumif....??

    Hi Forum I am trying to simplify a roster spreadsheet for payroll. Sheet 1 Roster - job, staff and days working <tbody> Job shift hours mon tue wed thur fri job 1 0930-1800 sally bill tom bob sally job 2 0730-1600 bill sally bob pete bob job 3 0800-1630 tom bob sally tom pete job...

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
Back
Top