![]() We will double click on the fill handle tool which is the small plus sign you see at the bottom right of Cell F4.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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |