I've got a spreadsheet for a work rota.
The shifts are entered as text i.e. day, night, leave etc etc.
I want to calculate how many hours someone works in a week.
How do I 'make' excel read it so that day=9 (as in 9 hours) for example.
So day+day = 18 and so on?