Spreadsheet: 136446d1326654271-excel-2007-possibly-an-if-problem-as-well-as-formatting-sample-employee-timecard1
Sheet: Yearly Timesheet

Employee Name: |  |  |  |  |  |  |  | Date Started:
Year to date totals
Total hours worked: |  |  |  |  |  |  |  | Time In Lieu
Holiday Entitlement: |  | 29 |  |  |  |  |  | This figure Includes 9 Bank Holidays
Holiday Taken |  | 0 |  |  |  |  |  | Holiday Remaining
2012
2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | Week 5
Monday
Tuesday
Wednesday
Thursday |  | 40
Friday
Saturday
Sunday
Total weekly hours
Jan. total: Regular hours
Jan. total: Time In Lieu |  | -5
2012-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Feb. total: Regular hours
Feb.  total: Time In Lieu
March |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Mar. total: Regular hours
Mar.  total: Time In Lieu
April |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Apr. total: Regular hours
Apr. total: Time In Lieu
May |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
May total: Regular hours
May total: Time In Lieu
June |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
June total: Regular hours
June total: Time In Lieu
July |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
July total: Regular hours
July total: Time In Lieu
August |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Aug. total: Regular hours
Aug. total: Time In Lieu
September |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Sept. total: Regular hours
Sept. total: Time In Lieu
October |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Oct. total: Regular hours
Oct. total: Time In Lieu
November |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Nov. total: Regular hours
Nov. total: Time In Lieu
December |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Dec. total: Regular hours
Dec. total: Time In Lieu
 |  |  |  | 2013
January |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday |  | 0
Tuesday |  | 0
Wednesday |  | 0
Thursday |  | 0
Friday |  | 0
Saturday |  | 0
Sunday |  | 0
Total weekly hours
Jan. total: Regular hours
Jan. total: Time In Lieu
February |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Feb. total: Regular hours
Feb.  total: Time In Lieu
March |  | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours
Mar. total: Regular hours
Mar.  total: Time In Lieu