Time Tracking Log
[Company Name] Today This Week
Date: 5/9/19 5/6 0
HOURS 0 5/7 0
Name: 5/8 0
5/9 0
Current Period 5/10 0
Start: 2/9/15 5/11 0
End: 2/16/15 (7 days) 5/12 0
HOURS 14.5 TOTAL 0
Start Breaks End Current
Date Project ID Task ID Hours Billed Invoice #
Time (minutes) Time Period
2/9/15 Other Holiday 9:00 AM 0 5:00 PM 8.00 yes x
2/10/15 Hello 9:30 AM 45 3:00 PM 4.75 yes
2/11/15 Panget 8:00 AM 15 10:00 AM 1.75 yes
2/14/16 Customer 3 12:00 AM 200 9:00 PM 17.67 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
0.00 no
Time Tracking Template by [Link] © 2013 Vertex42 LLC
Pivot Table Report
Current Period - all -
Billed - all -
Project ID Task ID Sum - Hours
(empty) (empty) 0.00
(empty) Result 0.00
Other Holiday 8.00
Other Result 8.00
Customer 3 (empty) 17.67
Customer 3 Result 17.67
Hello (empty) 4.75
Hello Result 4.75
Panget (empty) 1.75
Panget Result 1.75
Total Result 32.17
Projects and Tasks Instructions
Active Project ID Task ID This worksheet defines the list items u
x cali beach the TimeLog worksheet.
x hello
x pange Edit the Projects and Tasks table (colum
x Customer 4 in the Active column if you want the pro
x Other Holiday
x Other Sick Leave Each time you make changes to the Pro
x Other Vacation the right by going to Data > Refresh All,
To deactive a project or task (so that it
the Active column.
Pivot Table for the Project ID drop-down
Active
Project ID
cali beach
Customer 4
hello
Other
pange
(empty)
t defines the list items used for the Project ID and Task ID drop-down lists in
orksheet.
ts and Tasks table (columns A:C) and sort by Project ID and Task ID. Enter an "x"
olumn if you want the project/task to show in the drop-down lists.
make changes to the Projects and Tasks table, update the two Pivot Tables on
ng to Data > Refresh All, or press CTRL+ALT+F5.
roject or task (so that it does not show in the drop-down lists), delete the "x" in
mn.
ect ID drop-down Pivot Table for the Task ID drop-down
- all - Active - all -
(empty) Project ID Task ID (empty)
Other Holiday
Vacation
Sick Leave
Time Tracking Template
By [Link]
[Link]
© 2013-2018 Vertex42 LLC
This spreadsheet, including all worksheets and associated content is a
copyrighted work under the United States and other copyright laws.
Do not submit copies or modifications of this template to any website or online
template gallery.
Please review the following license agreement to learn how you may or may
not use this template. Thank you.
License Agreement
[Link]
Do not delete this worksheet
