How to do a time management spreadsheet

Projects and Tasks: Delete all the dummy information in the scheduling cells.

how to do a time management spreadsheet

Overtype the fictitious name with the name of one of your employees. These features may require a more advanced knowledge of Excel to set up, but that part has already been done for you.

Time Tracking Template

Just follow the few simple instructions in the worksheet to get started using the time tracker. Recording minutes worked: Select where to save your new schedule.

how to do a time management spreadsheet

Repeat steps 5 and 6 to add each employee to be included on the first day of your schedule. If you did add or delete some rows, you would need to add or delete corresponding rows in each daily section of the schedule. Check out these free business templates [Downloads]: The time tracking log table uses Excel's special Table feature, so you can add more rows to the bottom by just dragging the bottom corner of the table down.

how to do a time management spreadsheet

After you bill for hours worked, update the time log by putting an "x" in the Billed column. The invoice number is not used anywhere else in the template.

12 Steps to a Microsoft Excel Employee Shift Schedule

Still not interested in creating your own excel schedule template? To create invoices, you'll need to know how many hours were worked on various projects or for various customers. You May Also Enjoy.

how to do a time management spreadsheet

Updating Pivot Tables: You can also insert rows in the table the traditional way. If you prefer to follow along with an infographic — use our 12 step infographic to build your first shift schedule. The spreadsheet does not include an invoice, but you can download an invoice template to use along with this time tracker. Read what our customers say. The top of the worksheet summarizes total hours worked for the current day, the current week, and a custom time period that you can change by entering the start and end dates.