TimeSheet-Calculator_TrumpExcelRevised-2017_v1.xlsx

	B	C	D	E	F	G	H	I	J
1	Weekly TimeSheet Calculator
2	Wayne Enterprise								How to use this template
3	Employee Name:		Alfred Pennyworth
4	Department:		Housekeeping						Visit TrumpExcel.com for more Excel Templates
5	First Line Manager:		Bruce Wayne						Visit TrumpExcel.com for more Excel Templates
6
7
8		Year	Month	Date	Weekend
9		2017	February	1	Sat & Sun
10
11		Start Time	Regular Hours	Regular Pay (hourly)	Overtime Pay (hourly)
12		9:00	6	30	50
13
14
15	Day	Date	In Time	Out Time	Break Hrs	Regular Hrs	OT Hours	Total Pay
16	Wed	01	9:00	18:00	1.0	5.0	3.0	300.0
17	Thu	02				0.0		0.0
18	Fri	03				0.0		0.0
19	Sat	04				0.0		0.0
20	Sun	05				0.0		0.0
21	Mon	06				0.0		0.0
22	Tue	07				0.0		0.0
23
24				Weekly Summary	1.0	5.0	3.0	300.0
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
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