Monthly timesheet template - My Hours

	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Spreadsheet is read-only. Go to File > Make a Copy to create an editable sheet.
2	Monthly timesheet
3												Employee time tracking for Projects and tasks.
4	EMPLOYEE:	Vincent Vega, Visual Designer, OEM Department						START OF MONTH		1/4/2022		Automate your timesheets - it's Free
5
6	SUPERVISOR:	John Malkovich, Head of Design, OEM Department							REGULAR HRS	8.00	➔	Regular hours are used to calculate Overtime hours
7
8	DATE	Start time	Finish time	Regular hrs	Overtime	Sick	Vacation	Holiday	Other hrs	TOTAL HOURS	➔	Cells with non-white background are automatically calculated. When needed you can override the calculation with custom data.
9	Fri, 1 Apr	10:00 am	12:00 pm	2.00	0.00	6				8.00			2.00
10	Sat, 2 Apr			0.00	0.00					0.00	➔	Change the time format from AM/PM to hh:mm by selecting Start and Finish columns and click "Format" in the top bar.	0.00
11	Sun, 3 Apr			0.00	0.00					0.00			0.00
12	Mon, 4 Apr	2:00 pm	6:30 pm	4.50	0.00		4		-0.5	8.00	➔	Enter breaks as negative hours in "Other hrs" to subtract from "Total hours"	4.50
13	Tue, 5 Apr	8:00 am	4:30 pm	8.00	0.50					8.50			8.50
14	Wed, 6 Apr	8:00 am	7:00 pm	8.00	3.00					11.00	➔	When done 1. remove this column 2. save as XLS or PDF 3. send it to your supervisor.	11.00
15	Thu, 7 Apr			0.00	0.00	8				8.00			0.00
16	Fri, 8 Apr	10:00 am	12:00 pm	2.00	0.00					2.00			2.00
17	Sat, 9 Apr			0.00	0.00					0.00	➔	Use the "Blank timesheet" sheet to enter your hours	0.00
18	Sun, 10 Apr			0.00	0.00					0.00			0.00
19	Mon, 11 Apr	2:00 pm	6:30 pm	4.50	0.00				-0.5	4.00	➔	Other timesheet templates...	4.50
20	Tue, 12 Apr	8:00 am	4:30 pm	8.00	0.50					8.50			8.50
21	Wed, 13 Apr	8:00 am	7:00 pm	8.00	3.00					11.00			11.00
22	Thu, 14 Apr			0.00	0.00		4			4.00			0.00
23	Fri, 15 Apr	10:00 am	12:00 pm	2.00	0.00					2.00			2.00
24	Sat, 16 Apr			0.00	0.00					0.00			0.00
25	Sun, 17 Apr			0.00	0.00					0.00			0.00
26	Mon, 18 Apr	2:00 pm	6:30 pm	4.50	0.00				-0.5	4.00			4.50
27	Tue, 19 Apr	8:00 am	4:30 pm	8.00	0.50					8.50			8.50
28	Wed, 20 Apr	8:00 am	7:00 pm	8.00	3.00					11.00			11.00
29	Thu, 21 Apr			0.00	0.00			8		8.00			0.00
30	Fri, 22 Apr	10:00 am	12:00 pm	2.00	0.00	4				6.00			2.00
31	Sat, 23 Apr			0.00	0.00					0.00			0.00
32	Sun, 24 Apr			0.00	0.00					0.00			0.00
33	Mon, 25 Apr	2:00 pm	6:30 pm	4.50	0.00				-0.5	4.00			4.50
34	Tue, 26 Apr			0.00	0.00			8		8.00			0.00
35	Wed, 27 Apr			0.00	0.00		8			8.00			0.00
36	Thu, 28 Apr	8:00 am	4:30 pm	8.00	0.50					8.50			8.50
37	Fri, 29 Apr	8:00 am	7:00 pm	8.00	3.00					11.00			11.00
38	Sat, 30 Apr			0.00	0.00					0.00			0.00
39	Sun, 1 May			0.00	0.00					0.00			0.00
40	TOTAL H	---	---	90.00	14.00	18.00	16.00	16.00	-2.00	152.00
41	HOURLY RATE	---	---	$50.00	$50.00	$0.00	$0.00	$0.00	$0.00	---
42	TOTAL PAY	---	---	$4,500.00	$700.00	$0.00	$0.00	$0.00	$0.00	$5,200.00
43
44										152.00
45	EMPLOYEE SIGNATURE				DATE					TOTAL HOURS
46
47										$5,200.00
48	SUPERVISOR SIGNATURE				DATE					TOTAL PAY
49
50
51
52	Automate your timesheets with My Hours - it's Free
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100