This free downloadable employee timesheet in Excel is very easy to customize. To use its features, just enter the specific time you started and stopped working (both morning and afternoon shifts). Once these details are entered, the template will automatically calculate the total number of hours you have worked in each day, as well as the weekly total number of hours.
This employee time-in/time-out template is flexible in terms of your weekly working days. You only need to enter the start date of your work week, and the template will automatically generate the rest of the weekly calendar dates. The specific day of the week is also automatically generated once you assign a start date.
Download the free employee timesheet now
This time-in time-out timesheet is available in three downloadable variations. To start using, just select the download button below the image of the template format you like to get. Each format shares the same features. Steps and instructions in using the timesheet is provided below.
Steps in Using the Employee Timesheet
- Enter your company name and employee name.
Enter the start date of your work week.
When you input the start date, follow the format "MM/DD/YYYY" (month/date/year). Once the start date is entered, the remaining days of the work week will be automatically filled out for you. The column that indicates the specific day of week will also be auto-generated.
Fill out the details for the time-in and time-out section of the template.
To input your working hours, make sure you put a space in between the time and the word AM/PM (Example: 8 am, 6 pm, etc.). You can also input based on how the time looks like in the template (e.g. 8:00 am, 12:00 pm, 1:30 pm, etc). Once the daily time-in and time-out section is completed for the day, the total daily and weekly hours will be automatically computed.
In the image above,the column in letter "I" (circled in yellow green) shows the total number of hours you have worked in a certain day. That will be automatically calculated for you based on the time-in and time-out details you have entered.
- Review, email, or print your timesheet.