working pattern

  1. H

    Formula for calculating hours for specific work pattern.

    Hi All, Looking for some guidance on an excel formula to calculateworking hours for Monday to Thursday 08:30 – 17:00 and Friday 08:30 – 13:30. Theformula I’m currently using is below...
  2. M

    Network hours

    Hi Everyone, I have been trying to get this sorted for a while but no luck. I have a spreadsheet (obviously), i have several hidden columns which automatically capture the time and date that certain cells are populated. I want to subtract the difference between two of these cells as it will...
  3. I

    Is this impossible?

    People always ask 'can i add x amount of days to a date excluding weekends/holidays?' I want to know; Can I add x amount of days to a date, excluding specific days of the week i.e mondays and tuesdays? So if I want to add 20 days to a date but not count mondays or tuesdays? Is that possible...
  4. I

    Add X amount of days to a date Excluding certain days of week? i.e monday or tuesday

    Hello! I have visited perhaps every single excel forum post in the entire interwebs that is vaguely related to my excel problem and I cannot find an answer to my query. So, I thought I would just bite the bullet and ask for directions! I'll try and summarise my project first of all to give you...

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