Can this be done in Excel or other application

[almouchie]

basically What I am trying to do or want is

I want to optimize my labor schedule for the whole year

I have 3 shifts( A, B, C) that cover 24 hours a day.

On fridays, Satur, Sunday only 2 shifts are required
2 out of three shift need to work no less than 60 hours a week
& the other one(C) no less than 48 hours

whereby any hours above that is paid overtime per hour
Preferably the first shift starts at 7 in the morning
& each shift should get at least one day off

I have started doing Feb till May manually but I was wondering if its is feasible to be automated for the whole year in excel using VBA or other tool

thanks for any help

 

[XLGibbs]

http://vbaexpress.com/forum/showthread.php?p=58742#post58742

Cross post. Replies have started at VBAX. Please post links to cross posted questions in the future.

Responses to this should be directed at the VBAX site.

 

[almouchie]

noted
http://vbaexpress.com/forum/showthread.php?p=58742#post58742