Most valuable professional
  • Hot Topics

Excel Calculating Number of Staff for Making a roster

Hi Excel Gurus, I am stucked on this, hope someone can help Office is open 365 days a year Shifts run each day Mon - Thursday 02:00 to 10:00 (3 persons in shift) 10:00 to 18:00 (3 persons in shift) 18:00 to 02:00 (3 persons in shift) Except for Friday & saturday 02:00 to 10:00 (3 persons in shift) 10:00 to 18:00 (3 persons in shift) 18:00 to 02:00 (5 persons in shift) No of staff duties = 67 for a week Each person is allowed 1 day off in a week and is entitled to 14 days leave in a year. I need to calculate the total number of staff required to cover day off in a week and the 14 days leave. Thanks in advance. Maz

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of October 18, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel