Text to numbers

Hi I have a works schedule that I need to put a formula in to calculate staff in,on holiday, rest, cpc and extra shift then put it into the relevant boxes/totals underneath

Sorry if it's a simple one I'm still learning.

Many thanks for your assistance 

Mark