Sheet 1: Instructions

	
	
	

		
How to use Replicon’s Free Weekly Timesheet Template
		
	

		
Si. No
		


	
	

		
1
		
Basic Information
	
	

		


		
Customize your template with the following information:
	
	

		
a)
		
Company Name and Address
	
	

		
b)
		
Employee Name
	
	

		
c)
		
Supervisor Name
	
	

		
d)
		
Location
	
	

		
e)
		
Hourly Pay ($)
	
	

		
f)
		
Overtime Pay ($)
	
	

		
g)
		
Regular Hours
	
	

		


		


	
	

		
2
		
Timesheet Data
	
	

		


		
In this section, either supervisor or employee can enter the data:
	
	

		


		
Note: Time should be in hh:mm format (24-hour format). For example, 6 AM should be 06:00 and 6 PM should be 18:00.
	
	

		
a)
		
Date
	
	

		
b)
		
Start Time
	
	

		
c)
		
End Time
	
	

		
d)
		
Break
	
	

		
e)
		
Vacation / Sick Hours
	
	

		


		


	
	

		
Some of the checkpoints to keep in mind while using the excel sheet
		
	

		
a)
		
Make sure that the ‘Start Time‘ is not later than ‘End Time‘. In case you try to enter wrong value, the cell will turn to red color.
	
	

		
b)
		
Enter ‘Break‘ in hh:mm format.
	
	

		
c)
		
Do not change any formulas present in the weekly timesheet template. Only add/delete entries in start time, breaks, end time and vacation / sick hours columns.
	
	

		
d)
		
Regular hours, overtime hours and total hours will be automatically calculated. Overtime hours will be calculated if you exceed 8 hours of regular work-time in a day.
	
	

		


		


	
	

		


		
	

		
Try Replicon's advanced time tracking solutions in case you want to automate the tracking process. 
		
	

		


		


	
	

		
Additionally you can visit this page to get a free demo of our software!