In column C, type the formula: =SUM(B2-A2)*24 and drag down. Hours Worked. Step 3. Now, to calculate pay for the employee: In cell H1, type ...
確定! 回上一頁