OK so there are a number of different shifts in operation here and I want a total hours formula.
problem is the rota is written using a number of different notations for different shifts
some are 2-FIN some are 7-5PM some are EARLY or LATE
now I know what each shift is in terms of hours, but I want a way to get excel to calculate them, now I suppose I could create a table with a load of possible shifts and their total hours and then have excel match the rota to the table and sum total hours for the week
but I have no idea how to do this, all my attempts at this come back as problem with your formula and no further explanation