To calculate an employee's working hours:計(jì)算一個(gè)員工的工作時(shí)間
Enter the following formula into a cell: 在一個(gè)單元格里輸入下面的公式 =C2-B2+IF(B2>C2,1) The number 1 in the IF formula equals 24 when working with time. 數(shù)字1在IF公式里相當(dāng)于24 For example, in D4 the calculation is 例如在D4單元格計(jì)算如下: 6.00 - 20.31+ 24.00 = 9.29.
更多建議: