Spreadsheet: 89914d1289660798-excel-formulas-for-timesheets-excel_template_employees
Sheet: template

 |  | 1 |  |  | 1 |  |  | 1 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 |  |  | 1 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 1 |  |  | 0
Name of the employee | hours according to labor contract/day | 2010-10-01 00:00:00 | 0 | 0 | 2010-10-02 00:00:00 | saturday | 0 | 2010-10-03 00:00:00 | 0 | sunday | 2010-10-04 00:00:00 | 0 | 0 | 2010-10-05 00:00:00 | 0 | 0 | 2010-10-06 00:00:00 | 0 | 0 | 2010-10-07 00:00:00 | 0 | 0 | 2010-10-08 00:00:00 | 0 | 0 | 2010-10-09 00:00:00 | saturday | 0 | 2010-10-10 00:00:00 | 0 | sunday | 2010-10-11 00:00:00 | 0 | 0 | 2010-10-12 00:00:00 | 0 | 0 | 2010-10-13 00:00:00 | 0 | 0 | 2010-10-14 00:00:00 | 0 | 0 | 2010-10-15 00:00:00 | 0 | 0 | 2010-10-16 00:00:00 | saturday | 0 | 2010-10-17 00:00:00 | 0 | sunday | 2010-10-18 00:00:00 | 0 | 0 | 2010-10-19 00:00:00 | 0 | 0 | 2010-10-20 00:00:00 | 0 | 0 | 2010-10-21 00:00:00 | 0 | 0 | 2010-10-22 00:00:00 | 0 | 0 | 2010-10-23 00:00:00 | saturday | 0 | 2010-10-24 00:00:00 | 0 | sunday | 2010-10-25 00:00:00 | 0 | 0 | 2010-10-26 00:00:00 | 0 | 0 | 2010-10-27 00:00:00 | 0 | 0 | 2010-10-28 00:00:00 | 0 | 0 | 2010-10-29 00:00:00 | 0 | 0 | 2010-10-30 00:00:00 | saturday | 0 | 2010-10-31 00:00:00 | 0 | sunday
 |  | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | Leave | start program | end program | 1st worked Sunday | 2nd worked Sunday | 3rd worked Sunday
George | 08:00:00 | R |  |  |  | 16:00:00 | 00:30:00 |  | 13:30:00 | 22:00:00 | L |  |  | L |  |  |  | 06:00:00 | 14:30:00 |  | 05:00:00 | 13:30:00 |  | 13:30:00 | 22:00:00 |  | 13:30:00 | 22:00:00 |  | 21:30:00 | 06:00:00 |  | 21:30:00 | 06:00:00 |  | 21:30:00 | 06:00:00 | L |  |  | L |  |  |  | 14:00:00 | 22:30:00 | W |  |  | W |  |  | CO |  |  | CO |  |  | CO |  |  | CO |  |  | CO |  |  | W |  |  | W |  |  | CO |  |  | L |  |  | L |  |  |  | 05:00:00 | 13:30:00 |  | 05:00:00 | 13:30:00 |  | 05:00:00 | 13:30:00 |  | 05:30:00 | 14:00:00 | 2010-10-03 00:00:00 | 2010-10-10 00:00:00
[NAME] | 08:00:00 |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 | L |  |  | L |  |  |  | 21:30:00 | 06:00:00 |  | 21:30:00 | 06:00:00 | W |  |  | L |  |  |  | 21:30:00 | 06:00:00 | L |  |  |  | 05:30:00 | 14:00:00 | CO |  |  | W |  |  | W |  |  | CO |  |  | CO |  |  | CO |  |  | CO |  |  | CO |  |  | W |  |  | W |  |  |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 | L |  |  |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00 |  | 05:30:00 | 14:00:00
Andreas | 04:00:00 | CO |  |  | W |  |  | W |  |  | CO |  |  | CO |  |  | CO
Rahel | 08:00:00 |  | 14:00:00 | 22:30:00 | W |  |  | W |  |  | BO |  |  | BO |  |  | BO |  |  | BO |  |  | BO |  |  | W |  |  | W |  |  | BO |  |  | BO |  |  | BO |  |  | BO |  |  | BO |  |  | W |  |  | W |  |  | BO |  |  | BO |  |  | BO |  |  | BO |  |  | BO |  |  | W |  |  | W |  |  | L |  |  | L |  |  |  | 06:00:00 | 14:30:00 |  | 06:00:00 | 14:30:00 |  | 06:00:00 | 14:30:00 |  | 06:00:00 | 14:30:00 |  | 06:00:00 | 14:30:00