Countersignature Weekly Timesheet Template Made Easy

Initial monthly timesheet template

hi today we'll have a look at how to use the excel timesheet template first let's go into the settings page this page allows you to enter and change parameters to set up your timesheet we can first set up the current year we'll leave it at 2020 then lower you can enter the employee id his name and department the section below regular hours allows you to enter a standard number of hours worked in a day for a weekday monday to friday a saturday and a sunday here we have a basis of an eight hour work day for every day but saturdays and sundays finally the last section allows you to enter a list of reason for absence you can change the existing ones and have up to nine reasons great now let's head to the main data input section the timesheet as you can see there are 12 tabs one per month each breaking down the daily schedule fill in the first few days together let's say on the 1st of january our employee did not work we will leave the time in lunch start lunch end and time out sections blank we will only fill in the cause of absence which is in our case time paid holiday in the absence and hours which is eight as it is our standard workday hours let's move on to the 2nd of january our employee started working at 8 a.m had lunch at 12 ended his lunch at 1 and finished work at five as you can see the worked hours regular hours and overtime automatically calculate our worked hours is eight as are our regular hours which makes an overtime of zero hours finally let's input data for the third he started at eight had lunch at 12 ended his lunch at 1 30 and finished work at 7. as you can see he worked nine and a half hours that day which is one and a half hours over time great now that we've entered data we're ready to look at the report firstly the scored board header it indicates the most important metrics starting from the number of work days the overtime and days the number of sick days the absenteeism rate the number of holidays and the number of vacation days these numbers apply to the whole year next we have the worked hours versus regular hours and the overtime hours the first graph indicates if the employee has worked above or under the regular hours and the overtime hours indicates how many hours extra the employee has worked both of these graphs display the data per month next we have the absence reason it is just like the above two a monthly detail and it indicates the number of days absent per reason we have vacations holidays and sick leave the table underneath details the worked hours regular hours overtime hours sick leave holiday leave and vacation leave all in hours per month finally the last graph indicates the absenteeism rate that calculates based on the sick days compared to the total work days and that's it you know everything you need to know about our excel sheen template you're ready to start using it now enjoy