Timesheet Tracker.xlsx

	A	B	C	D	F	G	O
1	How to use						If this spreadsheet was useful at all, please let me know or suggest any changes (itsbigkiss@gmail.com)
2		Enter time without colon e.g.
3
4	JN	Start	End	Time			I would very much appreciate a virtual coffee if this has helped you:
5		1600	1700	1.00
6		0400	0500	1.00			https://ko-fi.com/bkg__
7
8		24- and 12-clock are fine but make sure it is four digits
9
10		The table to the right will automatically update unqiue JN - so if you work on a job at different points during the day, fill in the main table this will update e.g
11
12	JN	Start	End	Time	Unique JN	Total Time
13	Job 1	1000	1100	1.00	Job 1	2.25
14	Job 2	1100	1230	1.50	Job 2	1.5
15	Job 1	1230	1345	1.25
16
17
18		The weekly total table will calculate the days in which you've worked on each unique JN
19
20
21	Notes
22		Save this template, open each week and save as a new file for that week each time
23
24		The main table, unique JN table and weekly total are set to 49 rows, if you need more 1. look at you go
25		and 2. just remove the total row and drag the cell down to repeat the formula; in the weekly total, change the 49 of each number to your new number (e.g. A2:AXX)
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