T
Tel
Okay here's a challenge (well it was for me!)
I am creating a staff planner and need to count part-time staff hours.
the data that is entered has two variable
a7.5
a = type of absence;
T = training
S = sick
AL = Annual Leave
L = Lieu time
C = compassionate
CA = Carer's Leave
the number = the number of hours booked off
How do I seperate the two to make an additional column recognise the initial
letter and then total all occurences of that letter.
e.g. (Cell N11)= "AL5.5" + (Cell N15) = "AL2.5" would show in the Annual
Leave column as 8 hours leave (I would then reduce a further total column to
by the total)
If you need to view the planner go to www.tbgb.co.uk/plannerv1.xls
Any suggestions to improve on this would be most welcome.
Tel
I am creating a staff planner and need to count part-time staff hours.
the data that is entered has two variable
a7.5
a = type of absence;
T = training
S = sick
AL = Annual Leave
L = Lieu time
C = compassionate
CA = Carer's Leave
the number = the number of hours booked off
How do I seperate the two to make an additional column recognise the initial
letter and then total all occurences of that letter.
e.g. (Cell N11)= "AL5.5" + (Cell N15) = "AL2.5" would show in the Annual
Leave column as 8 hours leave (I would then reduce a further total column to
by the total)
If you need to view the planner go to www.tbgb.co.uk/plannerv1.xls
Any suggestions to improve on this would be most welcome.
Tel