hello all ,
I am doing some scheduling excel file , and I have in department different shifts , so in the schedule file I have already the formula that calculates how many people work in morning and how many in evening , but there is something missing A productivity is 60% , B productivity is 50% , C Productivity is 100%, A and B works morning, C is evening
100% SL SL L M
50% M M M M
60% E L E L
Productivity 1.1 0.5 1.1 1.5 how can I get these productivity number using formulas?
so the formula should count how man M , and multiple by the productivity indicator for the person.
Regards,
Trainder008
Bookmarks