Excel 2010 employee absence schedule issue

Hi

Thank you so much for the reply, appreciate it

I have attached the spreadsheet to this message

I can't work out where to put the divide the total count by 2 to get the half day for that key as don't need it on all of them