Spreadsheet: 786601d1657293079-payroll-formulas-needed-for-hours-pto-and-per-diem-payroll-data-report
Sheet: Labor Hrs

First Name | Last Name | Regular Time | Regular Time (Decimal) | Overtime | Overtime (Decimal) | Double Time | Double Time (Decimal) | Total | Total (Decimal) | Regular Cost | Overtime Cost | Double Time Cost | Labor Burden | Total Cost
Adam | Osborne | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 5192 | 0 | 0 | 0 | 5192
[NAME] | [NAME] | 1 day, 16:00:00 | 40 | 20:00:00 | 20 | 2 days, 1:04:00 | 49.07 | 4 days, 13:04:00 | 109.07 | 1120 | 840 | 2747.73 | 0 | 4707.73
[NAME] | Rojas-Zaragoza | 2 days, 0:00:00 | 48 | 17:00:00 | 17 | 01:00:00 | 1 | 2 days, 18:00:00 | 66 | 1728 | 918 | 72 | 0 | 2718
Amberley | McKenzie | 1 day, 6:00:00 | 30 | 00:00:00 | 0 | 00:00:00 | 0 | 1 day, 6:00:00 | 30 | 630 | 0 | 0 | 0 | 630
[NAME] | [NAME] | 3 days, 7:15:00 | 79.25 | 06:30:00 | 6.5 | 00:00:00 | 0 | 3 days, 13:45:00 | 85.75 | 1902 | 234 | 0 | 0 | 2136
Antony | Guillen-Hernandez | 3 days, 8:00:00 | 80 | 17:00:00 | 17 | 01:00:00 | 1 | 4 days, 2:00:00 | 98 | 1680 | 535.5 | 42 | 0 | 2257.5
[NAME] | Turner | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 3538.4 | 0 | 0 | 0 | 3538.4
Cameron | [NAME] | 3 days, 8:00:00 | 80 | 21:30:00 | 21.5 | 00:30:00 | 0.5 | 4 days, 6:00:00 | 102 | 2080 | 838.5 | 26 | 0 | 2944.5
Cathy | Jury | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 4038.4 | 0 | 0 | 0 | 4038.4
[NAME] | Hinrichsen | 3 days, 0:00:00 | 72 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 0:00:00 | 72 | 3357.36 | 0 | 0 | 0 | 3357.36
[NAME] | Yanez | 3 days, 7:30:00 | 79.5 | 1 day, 1:45:00 | 25.75 | 00:00:00 | 0 | 4 days, 9:15:00 | 105.25 | 1590 | 772.5 | 0 | 0 | 2362.5
[NAME] | Walker | 3 days, 0:00:00 | 72 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 0:00:00 | 72 | 2769.12 | 0 | 0 | 0 | 2769.12
[NAME] | Young | 3 days, 8:00:00 | 80 | 23:15:00 | 23.25 | 04:00:00 | 4 | 4 days, 11:15:00 | 107.25 | 1440 | 627.75 | 144 | 0 | 2211.75
George | Millward | 3 days, 8:00:00 | 80 | 17:00:00 | 17 | 00:00:00 | 0 | 4 days, 1:00:00 | 97 | 3200 | 1020 | 0 | 0 | 4220
[NAME] | Unruh | 3 days, 1:45:00 | 73.75 | 09:15:00 | 9.25 | 00:00:00 | 0 | 3 days, 11:00:00 | 83 | 1696.25 | 319.14 | 0 | 0 | 2015.39
J [NAME] | [NAME] | 2 days, 8:00:00 | 56 | 19:30:00 | 19.5 | 01:00:00 | 1 | 3 days, 4:30:00 | 76.5 | 2688 | 1404 | 96 | 0 | 4188
[NAME] | Aulgur | 3 days, 1:15:00 | 73.25 | 09:15:00 | 9.25 | 00:00:00 | 0 | 3 days, 10:30:00 | 82.5 | 2051 | 388.5 | 0 | 0 | 2439.5
Jaime | Rodriguez-Herrera | 2 days, 16:00:00 | 64 | 22:00:00 | 22 | 01:01:00 | 1.02 | 3 days, 15:01:00 | 87.02 | 2176.01 | 1122 | 69.13 | 0 | 3367.14
[NAME] | Hoover | 2 days, 20:15:00 | 68.25 | 16:51:00 | 16.85 | 04:00:00 | 4 | 3 days, 17:06:00 | 89.1 | 1842.75 | 682.45 | 216 | 0 | 2741.2
Jared | Hitomi | 2 days, 6:45:00 | 54.75 | 00:45:00 | 0.75 | 00:00:00 | 0 | 2 days, 7:30:00 | 55.5 | 985.5 | 20.25 | 0 | 0 | 1005.75
[NAME] | Tuck | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 4808 | 0 | 0 | 0 | 4808
[NAME] | [NAME] | 3 days, 8:00:00 | 80 | 14:00:00 | 14 | 00:15:00 | 0.25 | 3 days, 22:15:00 | 94.25 | 2640 | 693 | 16.5 | 0 | 3349.5
[NAME] | Martinez | 3 days, 0:00:00 | 72 | 18:30:00 | 18.5 | 00:30:00 | 0.5 | 3 days, 19:00:00 | 91 | 2304 | 888 | 32 | 0 | 3224
Jorge | Rodriguez | 3 days, 0:00:00 | 72 | 07:30:00 | 7.5 | 00:00:00 | 0 | 3 days, 7:30:00 | 79.5 | 2520 | 393.75 | 0 | 0 | 2913.75
[NAME] | O'Kennedy | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 6502.4 | 0 | 0 | 0 | 6502.4
Julian | Cuevas | 3 days, 0:00:00 | 72 | 18:45:00 | 18.75 | 03:00:00 | 3 | 3 days, 21:45:00 | 93.75 | 1440 | 562.5 | 120 | 0 | 2122.5
Justice | Hitomi | 3 days, 8:00:00 | 80 | 23:45:00 | 23.75 | 00:30:00 | 0.5 | 4 days, 8:15:00 | 104.25 | 2240 | 997.5 | 28 | 0 | 3265.5
[NAME] | Jauch | 2 days, 8:26:00 | 56.43 | 12:02:00 | 12.03 | 00:18:00 | 0.3 | 2 days, 20:46:00 | 68.77 | 2652.38 | 848.36 | 28.2 | 0 | 3528.94
Manuel | Guerrero | 2 days, 15:30:00 | 63.5 | 19:30:00 | 19.5 | 01:00:00 | 1 | 3 days, 12:00:00 | 84 | 1778 | 819 | 56 | 0 | 2653
Mark | Eveland | 3 days, 8:00:00 | 80 | 08:00:00 | 8 | 00:00:00 | 0 | 3 days, 16:00:00 | 88 | 2480 | 372 | 0 | 0 | 2852
Mark | Schilling | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 3384.8 | 0 | 0 | 0 | 3384.8
[NAME] | Novo | 3 days, 8:00:00 | 80 | 10:00:00 | 10 | 00:00:00 | 0 | 3 days, 18:00:00 | 90 | 2880 | 540 | 0 | 0 | 3420
[NAME] | O'Connell | 3 days, 8:00:00 | 80 | 21:13:00 | 21.22 | 00:41:00 | 0.68 | 4 days, 5:54:00 | 101.9 | 1760 | 700.15 | 30.07 | 0 | 2490.22
[NAME] | Hitomi | 3 days, 18:00:00 | 90 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 18:00:00 | 90 | 6706.8 | 0 | 0 | 0 | 6706.8
Payton | Beall | 3 days, 6:05:00 | 78.08 | 12:23:00 | 12.38 | 00:00:00 | 0 | 3 days, 18:28:00 | 90.47 | 1483.59 | 352.92 | 0 | 0 | 1836.51
Phat | Nguyen | 2 days, 8:27:00 | 56.45 | 12:04:00 | 12.07 | 00:18:00 | 0.3 | 2 days, 20:49:00 | 68.82 | 1129.01 | 362 | 12 | 0 | 1503.01
Ricardo | Greene II | 1 day, 22:16:00 | 46.27 | 05:30:00 | 5.5 | 00:00:00 | 0 | 2 days, 3:46:00 | 51.77 | 1295.47 | 231 | 0 | 0 | 1526.47
[NAME] | Baxter | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 4423.2 | 0 | 0 | 0 | 4423.2
[NAME] | Rudnick | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 3961.6 | 0 | 0 | 0 | 3961.6
Saran | Khamkhong | 2 days, 16:00:00 | 64 | 12:36:00 | 12.6 | 00:00:00 | 0 | 3 days, 4:36:00 | 76.6 | 1664 | 491.4 | 0 | 0 | 2155.4
Sergio | [NAME] | 3 days, 8:00:00 | 80 | 1 day, 9:30:00 | 33.5 | 04:00:00 | 4 | 4 days, 21:30:00 | 117.5 | 1920 | 1206 | 192 | 0 | 3318
[NAME] | Pyka | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 3461.6 | 0 | 0 | 0 | 3461.6
[NAME] | Torres | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 6923.2 | 0 | 0 | 0 | 6923.2
[NAME] | Gregorich | 3 days, 8:00:00 | 80 | 00:00:00 | 0 | 00:00:00 | 0 | 3 days, 8:00:00 | 80 | 4000 | 0 | 0 | 0 | 4000
Trent | Hallett | 2 days, 7:00:00 | 55 | 06:00:00 | 6 | 00:00:00 | 0 | 2 days, 13:00:00 | 61 | 1485 | 243 | 0 | 0 | 1728
Trevor | Cronin | 3 days, 6:15:00 | 78.25 | 18:15:00 | 18.25 | 00:15:00 | 0.25 | 4 days, 0:45:00 | 96.75 | 1956.25 | 684.4 | 12.5 | 0 | 2653.15
Trevor | Whitehead | 3 days, 7:45:00 | 79.75 | 12:00:00 | 12 | 00:00:00 | 0 | 3 days, 19:45:00 | 91.75 | 2472.25 | 558.01 | 0 | 0 | 3030.26
[NAME] | Blake | 3 days, 0:00:00 | 72 | 21:02:00 | 21.03 | 04:00:00 | 4 | 4 days, 1:02:00 | 97.03 | 2880 | 1262 | 320 | 0 | 4462
Zach | Keefover | 3 days, 8:00:00 | 80 | 21:15:00 | 21.25 | 00:30:00 | 0.5 | 4 days, 5:45:00 | 101.75 | 1760 | 701.25 | 22 | 0 | 2483.25
Zachary | Turner | 3 days, 7:00:00 | 79 | 11:40:00 | 11.67 | 00:00:00 | 0 | 3 days, 18:40:00 | 90.67 | 1580 | 350 | 0 | 0 | 1930