We have locked cell K1 as it will not change as a reference. In cell G2, write the Excel timesheet formula: Then, it should display the total working hours, if not the regular eight hours.įor this, we can use an IF function. Step 6 – In the “Regular” column, the regular hours are eight hours a day but let us say if the total number of working hours exceeds eight hours a day.Step 4 – Go to “Custom” and select “h:mm” for hours and minutes.Step 3 – We want our cell to be in the correct format, so right-click on the cell and go to the “Format Cells” and select the “General” category from the “Number” section.Let us insert the formula in the F2 cell to calculate the total time worked by an employee. Step 2 – In Excel, getting the format correct is the key.

Anything above that will be considered overtime.

read more so that the hours are 8 hours, 0 minutes, and 0 seconds. The arguments can take the following formats: hours, minutes, and seconds. We have used the TIME excel function TIME Excel Function Time is a time worksheet function in Excel that is used to calculate time based on the inputs provided by the user. Step 1 – First, let us input the standard working hours in cell K2.For the mandatory 8 hours, the pay is ₹500, while for overtime, the pay is ₹650. The standard working hours for the company are 8 hours. This total net pay comprises salary, wages, bonus, commission, deduction, perquisites, and other benefits.

For a company to calculate the time worked by its employees and the overtime time that has been done, it needs to calculate the payroll Payroll Payroll refers to the overall compensation payable by any organization to its employees on a certain date for a specific period of services they have provided in the entity.

Time calculation formula for excel