need help with a scheduling program for nurses

**Lakeside5** · 11-02-2006, 08:36 PM

not sure where to go, work in a hospital that does not have a scheduling program. WOuld like to come up with one that would work...need to input codes for example if a nurse works days it would say A (i need this to count for 7 am-7pm) P (would need to count for 7pm-7am) D (645-315) F ( 11 am- 11pm) E (9-5)etc. Need to have the collums add up the total of nurses

A
A
A
A
F
D
P
p

TOTAL DAYS:6
TOTAL EVEA:5
TOTAL EVEp2.5
noc:2

I Hope i added this up right, any help or suggections would be great!!!

**mrice** · 11-04-2006, 11:45 AM

I would suggest user defined functions here which would understand if the code fell into the day or evening category etc.

Something like

Function NurseCountDay(MyRange As Range)
NurseCountDay = 0
For Each Cell In MyRange
If Cell = "A" Or Cell = "D" Or Cell = "E" Then
NurseCountDay = NurseCountDay + 1
End If
Next Cell
End Function

**Lakeside5** · 11-04-2006, 02:05 PM

How do you do user defined functions. Thanks any help would be great.

**mrice** · 11-05-2006, 03:44 PM

You need to go to the VBA editor - Alt F11

Right Click on the workbook in the left hand pane and select add module

Paste the function I originally supplied into this blank sheet and edit as appropriate.

Go back to the Excel worksheet - Alt F11

Do Insert - Function. Select user defined and you should see the new function in the list.

Select the range of cells for the function to operate on and the cell should contain the answer.