how to use excel to creat an oncall schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i wantb to creat oncall schedule for doctors in a hospital. each 2 doctors
would be on call for 12 hours a day. it can look like calendar and it should
calculae how many days each one was oncall up to date.
 
Let's say we have twelve worksheets in a workbook, one for each month.

In each worksheet there would be one column for each doctor, doctor's name
in the top row. Rows 2 thru 32 could correspond to the days of the month.
Enter a 1 if the doctor was on-call that day.

At the bottom of each worksheet in row 35 enter formula like:

=SUM(A2:A32) and copy across.
 
Back
Top