Select and drag down to copy the formula to other cells.įigure 6: Regular time for Column E Calculating the Overtime We will double click on the fill handle tool which is the small plus sign you see at the bottom right of Cell E4.Select and drag down to copy the formula to other cells.įigure 4: Hours worked in Column D Calculating the Regular Work Time We will double click on the fill handle tool which is the small plus sign you see at the bottom right of Cell D4.We will insert the formula below into the cell.To ensure that we do not encounter problems, we will convert the time from its native unit to decimal hours in Column D. We will set up the data by inputting the Names, Time IN, Time OUT, and RATE for 7 employees in Column A, Column B, Column C, and Column G respectivelyįigure 2: Setting up the Data Calculating the Hours WorkedĮxcel calculates time as fractions of a day.=(regular time*rate) + (overtime*rate*1.5) Formula The steps below will guide all levels of excel users through the process.įigure 1: How to Use Basic overtime calculation formula General Formula
We can use a set of formulas to calculate the pay associated with workers working overtime.
