Hi jo,
I think Roger's solution is close to the mark. I have used the following
variation on it'-

Try the following formula into C3 and copy it down column C

=COUNTIF(B2,"LD")*12+COUNTIF(B2,"ND")*8+COUNTIF(B2 ,"SD")*5

Sunday 08/10/2006 LD 12 Total 112
Monday 09/10/2006 ND 8
Tuesday 10/10/2006 SD 5
Wednesday 11/10/2006 LD 12
Thursday 12/10/2006 ND 8
Friday 13/10/2006 SD 5
Saturday 14/10/2006 LD 12
Sunday 15/10/2006 ND 8
Monday 16/10/2006 SD 5
Tuesday 17/10/2006 LD 12
Wednesday 18/10/2006 ND 8
Thursday 19/10/2006 SD 5
Friday 20/10/2006 LD 12



Best regards
Jerrydes



"jo" wrote in message
...
i am trying to create an off duty rota of which to give to colleages, i
need
to display their shifts in alphabetical letters ('LD' long day) which
denote
a numerical value (12) for hours of shift, in order to have a cumulative
total, please assist.