New improved simple Excel 2013 Timesheet

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:

screenshot of Working Data's Excel 2013 timesheet demonstrating where to enter hourly rate

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.

Timesheet version 2 screenshot showing how to enter your starting and finishing times

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.

Timesheet version 2 screenshot showing auto calculation of weekly billing totals. New version in Excel 2013

We hope you find the Timesheet useful.

Other blog posts you might find useful:

  1. Simple Excel Mileage Claim Tool
  2. Markup and Margin Tool
  3. A guide to upgrading from spreadsheets

If you have more advanced requirements regarding timekeeping or payroll, contact us to find out more about what an Access database could do for your business.

Leave a Reply

Your email address will not be published. Required fields are marked *