How to Make Work Schedule!

MWhiteDesigns

Well-known Member
Joined
Nov 17, 2010
Messages
646
Office Version
  1. 2016
Platform
  1. Windows
hey Guys,
Back again! I was hoping someone would be able to help.

heres the short of it on a small scale.

I want to be able to make a "work" schedule based of associates availability.

Mark Can work Mon, Tues, Wed Friday Sunday from 5am-11pm and 2pm-9pm.
Danny can work Mon, Tues, Wed Sat Sunday only from 11-5
Matt can work Wed, Thurs Friday from 5am-10am and 2pm-11pm.

Based off these values, is there a way for excel to mix and match their avilability to cover each day for a given month from open 5am to Close 11pm??

Does that make sense?

any help or insight would be amazing~!

Once again, thank you so much in advance!
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
Getting Excel to allocate people to each slot will be difficult (though probably not impossible).

You would also need to plug in any other constraints, such as maximum allowable working hours per week, and minimum number of people required at a time.

What would be much simpler, would be to build a calendar where you manually allocate people to days and times, and Excel warns you if you have not filled all the required slots, and warns you if you have allocated people to the wrong slots, and maybe even prevents you allocating them to the wrong slot.
 
Upvote 0
I believe anything would help rather than manually laying out 20 different sheets and trying to do it by hand while making sure you mach every ones availability. Anyway to make a small example of what you suggest above? I have no clue on what the code would look like. I am relatively new to excel and still trying to learn (at the beginning stages)
 
Upvote 0

Forum statistics

Threads
1,224,598
Messages
6,179,820
Members
452,946
Latest member
JoseDavid

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