create time sheet from rota

Every month the manger does a rota for all staff in an excel sheet.

I'm trying to write a formula that will kind of automate the process of time sheets a bit rather than everyone referencing the rota and writing a time sheet out in pen and paper.

I've attached what I've done so far, but I'm sure there's a better way to do this?

At the moment I'm just summing a bunch of countif's which have the different rota day's put into them

The shift patterns are exactly that, different timings of shifts

e = 07:30 - 15:30
ls = 15:00 - 23:00 then sleep in at the location


I'll leave it there for now as I might fill this post up with lots of useless info, but if you want any more just let me know.

Thanks