| Row | Day | Date | Time In | Time Out | Hours | Daily Hrs | Amount | Weekly Amount | Total Amount | Project ID | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | =A2 |
=B2 |
=D2 |
(input) |
==HOUR(D1-C1) + (MINUTE(D1-C1)/60) |
=IF(A1=A2,F2,0) + IF(TRIM(J1)="",0,E1) |
=F1*FS |
=E1*FS+H2 |
=E2*FS+I3 | 1234 | – |