For those of you who keep their hours and do a weekly invoice, this simple Excel 2013 timesheet will make keeping track of your hours as easy as pie. And it’s in the latest file version too (.xlsx).
Following the steps below will allow you to buile youd own timesheet, but if you’re short of time, why not take advantage of the time we’ve spent on ours!
Purchase the Timesheet Excel Tool
Click the button below to purchase the Timesheet Excel Tool.
Once you have completed your transaction on PayPal you receive the download link by email.
Entering your hourly rate
The first step is to enter your hourly rates. We have given you the option to put in different rates for Saturday and Sunday as these usually pay different. If they are the same, just put the same rate as for Monday to Friday in each of the three hourly rate boxes.
When you open Timesheet v2.0 you will see this:
Once you have put in your hourly rates, it is time to start entering your hours.
Entering your hours
Enter the start and finish times using the format (hh:mm) using the 24-hour clock. Remember to separate the hours and minutes with a colon : (next to the L key) and not a full stop.
Once you have entered the start and finish times and your lunch break mins (which are deducted), Timesheet will calculate the hours and the value for that day.
- 07:30 to 16:30 = 9 hours
- 9 hours – 30 mins lunch = 8.5 hours
- 8.5 hours * £10.00/hour = £85.00
In this example our chap started at half seven in the morning and finished at four thirty in the afternoon with a half hour lunch break. That gives eight and half hours chargeable time. Multiply that for the hourly rate for Monday (£10/hr) and you get ten times eight and half which is eighty five pounds. If you don’t take a lunch break or it is not deducted then just enter a zero in that cell.
Calculating your weekly totals
As you enter the times and lunch breaks for each day in the week, Timesheet v2.0 will automatically calculate your total hours and billings for you in the bottom row marked TOTALS. Here’s one with Monday and Tuesday filled in.
We hope you find the Timesheet useful.
Other blog posts you might find useful: