Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How can I use Excel to schedule students for classes? | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
How do I create project schedule using excel - office 2000 | Excel Discussion (Misc queries) |