automatic summation in columns

I attached excel sheet with employee attendance. If you press CALCULATION BUTTON, then macro creates one sheet for each employee. In new created sheets is column with work time. So in the end of this column I would like to see sum of hours. Cell with total time should has blue colour.
Cells with employee name should have red colour and columns of lunch should have yellow colour.
Is somebody who knows how to adjust macro?

Thanks very much