Scribd
Upload
126 views4 pages

Time Tracking Template Guide

The document is a time tracking log for a company tracking hours worked from 2/9/15 to 2/16/15. It shows the name, date, project/task, hours worked, billing status, and invoice number for each entry. A total of 14.5 hours were logged over the 7 day period for projects including "Other" and "Customer 1".

Uploaded by

Jessica Kling
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
126 views4 pages

Time Tracking Template Guide

The document is a time tracking log for a company tracking hours worked from 2/9/15 to 2/16/15. It shows the name, date, project/task, hours worked, billing status, and invoice number for each entry. A total of 14.5 hours were logged over the 7 day period for projects including "Other" and "Customer 1".

Uploaded by

Jessica Kling
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Time Tracking Log

[Company Name] Today This Week


Date: 1/19/24 1/15 0
HOURS 0 1/16 0
Name: 1/17 0
1/18 0
Current Period 1/19 0
Start: 2/9/15 1/20 0
End: 2/16/15 (7 days) 1/21 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 5:00 PM 8.00 yes x
2/10/15 Customer 1 9:30 AM 45 3:00 PM 4.75 yes
2/11/15 Customer 1 8:00 AM 15 10:00 AM 1.75 yes
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
0.00 no

Time Tracking Template by [Link] © 2013 Vertex42 LLC


Pivot Table Report
Current Period - all -
Billed - all -

Project ID Task ID Sum of Hours


(empty) (empty) 0.00
(empty) Result 0.00
Other Holiday 8.00
Other Result 8.00
Customer 1 (empty) 6.50
Customer 1 Result 6.50
Total Result 14.50
Projects and Tasks Instructions

Active Project ID Task ID This worksheet defines the list items used f
x Customer 1 the TimeLog worksheet.
x Customer 2
x Customer 3 Edit the Projects and Tasks table (columns A:
x Customer 4 "x" in the Active column if you want the proje
x Other Holiday
x Other Sick Leave Each time you make changes to the Projects
x Other Vacation the right by going to Data > Refresh All, or p

To deactive a project or task (so that it does


in the Active column.

Pivot Table for the Project ID drop-down


Active

Project ID
Customer 1
Customer 2
Customer 3
Customer 4
Other
(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
e column 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"
lumn.

oject 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

You might also like