Sum employee time using whole minutes
Enter net paid time
Copy paid hours and the minute remainder after removing unpaid breaks from each employee’s own record. Leave unused entries at zero.
Add minutes before formatting
Seven hours 45 minutes, eight hours and six hours 30 minutes add to 22 hours 15 minutes. The decimal form is 22.25 hours.
| Employee | Paid time | Minutes |
|---|---|---|
| 1 | 7h 45m | 465 |
| 2 | 8h 00m | 480 |
| 3 | 6h 30m | 390 |
| Total | 22h 15m | 1335 |