Excel Timesheet Templates

This is simple example of a Time sheet.

Instructions :
Type the week start date in cell C3, the Week beginning.
Use the format dd/mm/yy, the name of the day will appear automatically.
The date is then passed down to the Day column.

Type the amount of hours you are expected to work in G3, the Normal Hours.
This is used later to calculate if have worked over or under the required hours.

Type the times you arrive and leave work in the appropriate columns.
Use the format of hh:mm.

Note :

• The Total Hours cell has been formatted as [hh]:mm.
• This ensures the total hours can be expressed as a value above 24 hours.
• If the [hh]:mm format had not been used the Total Hours would show as : (17:00)
• If the [hh]:mm format does not show in the cell format dialog box
• on your computer, it can be created using Format, Cells, Number, Custom.