Employee Attendance woth OT – Formula base

Tracking employee attendance and their overtime. Simple but useful format in excel.

You can do the following things

1. Ask to punch for timings if they are coming to factory and going out but evening not coming back.
2. Insist on self attendance weekly/monthly keeping his/her boss in loop.

and many more.

Employee Timecard
Employee Name: E-mail: Year to date totals:
Manager: Phone: Regular hrs: 0.00 Overtime hrs: 0.00 Total: 0.00
January, February, March      Employee Timecard: Daily, Weekly, Monthly, Yearly
January Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jan. total: Regular hours 0.00 Jan. total: Overtime 0.00
February Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Feb. total: Regular hours 0.00 Feb.  total: Overtime 0.00
March Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Mar. total: Regular hours 0.00 Mar. total: Overtime 0.00
April, May, June      Employee Timecard: Daily, Weekly, Monthly, Yearly
April Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Apr. total: Regular hours 0.00 Apr. total: Overtime 0.00
May Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
May total: Regular hours 0.00 May total: Overtime 0.00
June Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
June total: Regular hours 0.00 June total: Overtime 0.00
July, August, September      Employee Timecard: Daily, Weekly, Monthly, Yearly
July Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
July total: Regular hours 0.00 July total: Overtime 0.00
August Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Aug. total: Regular hours 0.00 Aug. total: Overtime 0.00
September Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sept. total: Regular hours 0.00 Sept. total: Overtime 0.00
October, November, December      Employee Timecard: Daily, Weekly, Monthly, Yearly
October Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Oct. total: Regular hours 0.00 Oct. total: Overtime 0.00
November Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Nov. total: Regular hours 0.00 Nov. total: Overtime 0.00
December Week 1 Overtime Week 2 Overtime Week 3 Overtime Week 4 Overtime Week 5 Overtime
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Total weekly hours 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Dec. total: Regular hours 0.00 Dec. total: Overtime 0.00

 

Click Here To Download Employee Attendance