DAILY TIME TRACKING SHEET FOR EMPLOYEES HOW TO
DAILY TIME TRACKING SHEET FOR EMPLOYEES FULL

Select column G (“Actual working hours”).

This is how you can get Excel to automatically calculate the actual working hours of your employees:

To add more cells with the same properties, simply click on the small square in the lower right corner of your cell and drag it down. All Saturdays and Sundays should now be highlighted in color.ĭon’t worry: You only need to set up this complicated formatting, rules and formulas just the one time.

In the “ Fill” tab, select any color for marking the weekends and click “OK”.

Under “Format values where this formula is true,” copy the following calculation to the dialog box: =WEEKDAY($A1 2)>=6 (this formula means in plain language: “The following applies to all Saturdays and Sundays in column A”).

Under “Select a Rule Type:”, click “Use a formula to determine which cells to format”.

Click on “New Rule.” in the following menu.

Click on “Home”, then in the “Styles” section, you should see “ Conditional Formatting”.

Click on column A, hold down the mouse button and drag all the way to column H.

DAILY TIME TRACKING SHEET FOR EMPLOYEES FULL

Now drag the arrow downwards until the area covers a full seven-day week.

Click on the small square in the lower right corner of the selected cell A4 and hold down the mouse button.

The date is now displayed in long form and includes the day of the week.

Under the “Home” tab in the “Number” area, click the small arrow next to “Date” and select the “ Long Date” format.

In cell A4, enter the first date that you want to start recording the working time.

DAILY TIME TRACKING SHEET FOR EMPLOYEES HOW TO

Here’s how to add a continuous date to your Excel timesheet and highlight the weekends in color: Now all rows above cell A4 are fixed in place. Now click on the “Freeze panes” button under the “View” tab and select “ Freeze panes”.

Finally, freeze the upper three rows of your table so that they remain visible to the employee even when they scroll down.

The “Transfer format” button in the upper left corner of the menu helps you to speed up the design process. Connected cells and different fill colors can help to separate individual areas from each other. Keep the column widths consistent to create a better overview and be more visually appealing. Use bold writing and different fonts, sizes and colors as you see fit.

In row 3, enter the column headings “Date”, “Time in”, “Start of break”, “End of break”, “Time out”, “Absences”, “Actual working hours” and “Plus/minus hours” one after the other.

the HR department), the timesheet should be sent to and which subject the email should have.

Another aid: In row 2 you can explain which email address (e.g.

To do this, enter the formula =TODAY() in cell H1 and confirm by clicking on “enter”.

A small aid to help your employees: a current date display, which makes it easier for them to find the right row in the time sheet.This value serves as a reference for the calculation formulas that we plan to include later in the table. In cell D1, enter the daily target working time of the employee using the format hh:mm (h = hours, m = minutes), for example, 08:00 (8 a.m.).In cell A1, enter the name of the employee.Here is how you equip the header of the Excel spreadsheet with all the necessary information, set up the columns, and format your timesheet clearly:

Daily time tracking sheet for employees