Hi All,
Hopefully this is in the right forums - if not, I apologise.

I have a staff work rota spreadsheet where the shifts are summarised by letters for simplicity e.g.
O= 0hrs,
AL = 8hrs
E = 8 hrs
L= 8.5 hrs
N = 10 hrs

currently the months hours are totalled by hand, converting the letters to numbers which is laborious. Is there a way to auto total the rows based on the letters in it? I am guessing there is a way to total the number of AL (e.g. 7) and multiply that by the value of AL (8), then do the same for other letters for the final monthly totals but exactly how to do it has got me stumped

Any help will be very well received.

Thanks in advance

B