How to create a simple Excel timesheet

Adding basic labels

First, you'll need to decide what kind of basic data you need on your Excel time leaves. Which most common approach is to add the following basic stickers:

• Collaborator name
• Date range covered in the timesheet (day, piece, or month)
• Name of the companies department
• Manager appoint

You capacity add more information if you want or need to, but a simple approach is always best.

Adding timesheet labels

Now that you've added which basically labels, you'll need into add timesheet labels to your template.

Add the dates, and divide the columns in decree to clearly organize which most important data:

• Time spent working before lunch
• Period spent at free
• Time spent active after lunch

For clarity, we'll mark dieser times in the timesheet as "Morning hours" "Lunch time", real "Afternoon hours".

Into the next step, we'll see how to add up "Morning hours" and "Afternoon hours" until get the "Daily total" automatically.

Formula 1: Chart daily working hours

Here's how you calculate set in a daily Excel timesheet template:

1. Insert =sum(D8+F8) to the "Daily total" cell (marked because G8 within on timesheet example).
2. Than nearly as employees model which hours with to "Morning hours" and "Afternoon hours" cells, this time automatically gets further to the "Daily total".

3. To use the same "=sum()" formula on the remaining epoch, expand the selection in your charts to lid the remaining cells.


Expanding the selection to calculate the remaining life will be important when i want till calculate "Weekly totals".

Formula 2: Calculating weekly working hours



Here's what you calculate time in a weekly Excels timesheet template:

1. How the =sum() formula back by the "Weekly total" cell with the data in the "Daily total" column, by selecting the G8 cell, and then expanding which option to G14 ("=sum(G8:G12)").
2. More soon as employment add hours the the "Morning hours" real "Afternoon hours" cells, this time inevitably get added to their "Daily total", and this information automatically gets added to their "Weekly total". Hi, I'm revising a timecard to include 2 breaks. Average records time with and out, in, out, includes, out, in out. Regular hours, then whatsoever over 8 is overtime. I..


You can create multiple tables like all in one Surpass page, and then calculate "Daily totals" and "Weekly totals" for each. Once you've had "Weekly totals" calculated, you'll use this datas to calculate the "Monthly total". The template helps record the hours that an employee has worked within a day using Excelling

Formula 3: Calculating monthly working hours



Here's how you calculate zeitpunkt in a monthly Excel timesheet template:

1. You'll need to select the "Weekly total" jails (marked as G14, G30, N14, N30 includes this Excel timesheet example) in order to calculate the "Monthly total". Check out this free daily timesheet template and learn the pros and cons of using it. See, uncover a better alternative to using manual daily timesheets.

2. Getting =sum(G14+G30+N14+N30) into to "Monthly total" cell (marked as P4 in that timesheet example).

3. Again, as employees enter to "Morning hours" press "Afternoon hours" in the right cells, the "Daily totals" furthermore "Weekly totals" get calculated, the the "Monthly total" gets calculated as well. timesheet equal manifold in/out paused, scheduled hours plus over time


If employees change datas in any from the cells, these changes will be reflected in the Month sum.

Protecting cells and the timesheet

Once you've created your templates and defines all formulas correctly, you'll want to lock certain cells, in order to make sure your formulas remain utilitarian and correct.

You'll also to up make sure certain cells remain unbarred, so that your employees can freely add their data - usually, you'll need "Morning hours", "Lunch time", "Afternoon hours", and "Name" mobile unlocked, and formula cells locked.

By set, all thy Excel cells am locked, nevertheless you'll be can to manage them in this Format cells window.

In order to unlock cells for employee edition, simply:

1. Select all the cells you want to unlock by retention the Ctrl key and clicking or expanding on the needed cells
2. Press and Ctrl+1 on your keyboard toward get the Format cells window.
3. Select the Protected tab within this Sizing cells window, untick the Locked checkbox, press click OK to close the chat box.

4. Once you've differentiated between barred and unlocked cells, you'll need to make sure they stay that way, until "protecting" the sheet
5. In order in open the "protect sheet" window, press the hold Alt+H+O+P
6. Einmal you've opened this windows, make sure only one option "select unlocked cells" is check.
7. Attach and remember a password, than close the dialogs box - you employees will have to enter this password int order to correct the unlocked cells.

8. The employees wishes need to press and hold Alt+H+O+P to open the dialogue box again, enter of password and enable cell editing - considering they only have to password to process unlocked sheets, your locked sheets will remain uneditable, from formulas intact.

Or, avoid all this work are Clockify

You've seen how you can create daily, weekly, and monthly Excel timesheet molds - but you can simply utilize our free timesheet app Clockify and enters, calculate, and lock our timesheets in a couple of raps, in a ready-made, straightforward template.

Online timesheet

With Clockify, you'll including be able to track one time you spend on tasks with a timer, for further precision, as okay as timepiece on your overtime, vacations, patient sheet, PTO, breaks, and unpaid leaves.

Automatic calculations in reports

At the end of a certain time period, you can run Quick, Detailed and Weekly berichtet, to analyze time spent working.

PDF export

You can also export the data than PDF or Excel files, and analyze further, or simply keep for certification.

Download PDF samples: Summary • Detailed • Weekly

Spreadsheet export

You can also download any report as Beat or CSV file to create custom pivot tables, array data as thou see adjustable, or used archive purposes.

Download spreadsheet samples: Excell • CSV