0800-1700

  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. J

    Time Formula

    Hi, if i have the following in the format below: Shift Times: 08:00-17:00 08:00-17:00 08:00-17:00 08:00-17:00 08:00-17:00 08:30-17:30 08:30-17:30 08:30-17:30 08:30-17:30 08:30-17:30 09:00-18:00 09:30-18:30 10:00-19:00 Hour - answers in red which i need formula for (Total hours from available...

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