ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for adapting this time-tracking spreadsheet:
2
This spreadsheet can be used to track your time in academic (or other) areas. You can customize the categories and subcategories in whatever way best fits your needs.

There are three tabs that you will work with:
1. Data Entry: This is where you will track your time. You will describe the activity in Column A, select a Category and Subcategory for it, and then enter other relevant details and information.
2. Summary Statistics: After you configure this page, it will automatically update to display summary statistics in several forms: (a) aggregate pie chart of all categories; (b) raw hours on each category per month; and (c) proportion of time in each category per month. It is set up for July 2022 to August 2023 currently, so you will need to update the formulas and graphs to show current/future years and months.
3. Lists: This is where you will set up your categories, assign subcategories to each category, and create other levels for your dropdown menus on the data entry page as needed.

Conditional formatting is currently set up to highlight rows in a certain color based on which category is selected. If you change the categories, I recommend adjusting the conditional formatting for all rows/cells accordingly.
3
4
I am unable to grant editing access to this spreadsheet, but you are welcome to make a copy for your own use.
5
6
Note: I would recommend using this template in Excel. I cannot guarantee that it works the same way in Google Spreadsheets or any other program.

If you have any questions, you are welcome to email me: megan.rogers@txstate.edu. I will respond to you when I am able to.
7
8
Finally, if you share this template, please give me (Megan Rogers - https://faculty.txst.edu/profile/2378161) credit.
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
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