Recent content by karlhr

Hi All Some time ago I hada thorny question related to creating a work rota from which I could extract days, nights annual leave, sickness along with a few other nuggets. After posting on this forum I was pointed in the right direction. . After some fiddling I cracked the problem with VLOOKUP...

Some time ago I asked about how count text values in a rota to enable counting the number of staff on duty. Thank you for the assistance as I am now using COUNTIF with good results. My new question is this. Having a table with a column with staff names. Then a series of date columns below...

Phew . . . . many thanks for your response. A clear example makes life much easier. I had a eureka moment in the night woke up and realised "" helped me to create a rota which summarises. e.g. =IF(A2="D",1,0) Logical :-)combined with your examples, makes a simpler result. Am going to work on...

Thank you for your response. I got some of the way but one thing that is bugging me. How do I get the column to add up all the D or N separately so that I can confirm how many staff are on duty. To make life easier I have two columns per day, one for days, one for nights. How do I assign the...

I'm Karl from Mansfield in UK. I work in forensic mental health. Recently promoted to Charge Nurse, currently I have responsibility for running a 14 bed low secure unit my team is 20 plus strong. This means I have to do a variety of tasks which has included staffing rota's, times sheets, drugs...

I have to create a simple rota which requires to indicate The number of staff on duty The number of each grade on duty Any short fall or over staffing e.g. have the shortfall show in RED To make things easier to ready D = Day (10h 43m), N = Night (10h 43m) 9-5 = Regular working day (7h 30m)...