# 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.

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.

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.