how to use excel to creat an oncall schedule
 

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.

how to use excel to creat an oncall schedule
 

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.
--
Gary''s Student


"andy" wrote:

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.