Categories: HR

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

Related Sample Formats:

  1. Employee Performance With Attendance.
Hrformats

Leave a Comment
Share
Published by
Hrformats
Tags: AttendanceEmployeeOTwoth
12 years ago

Recent Posts

Letter to Announce an Employee Training Session for skills improvement

Whenever a company announces employee training session for skills development then it is supposed to…

3 months ago

Example Immediate Resignation Letter for Various Reasons

If you are planning to immediately resign from your job but you can have your…

3 months ago

Sample Letter to Accept to Serve in a Honorary Position

If you have been invited to serve in an honorary position at any institution and…

3 months ago

Warning Letter for Policy Violations Template, Example

Violating the policy of the company will not be accepted by any organization and if…

3 months ago

Sample Warning Letter to Restaurant Manager Example

Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…

3 months ago

Sample Grievance Letter to Supervisor for Retaliation

If there is retaliation that you have observed in a particular team or department then…

3 months ago