Spreadsheet: 21023d1208034635-crazy-formula-please-help-overtime-overtime-sample-code-added
Sheet: Sheet1

2170 | B Paramedics | Bal. Fwd
3567 |  |  | A100107 | A100707 | A102207 | A102807 | R111507 | R112107 | A120307 | A120907 | A010408 | A012008 | A022508 | A030808 | A032608
3567 | SAVARESE  7348 | 3378 | 7 | 12 | 9.5 | 24 | 24 | 12 | 12 | 24 | 12 | 24 | 12 | 12 | 4.5
3531 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3531 | WOERNER    7365 | 3531 | 0
3511.5 |  |  | A051307 | A061807 | A071507 | A080507 | A081707 | A090707 | A100407 | A102207 | A110607 | A112407 | A112707 | A120307 | A120907 | A121507 | A123007 | A010808
3511.5 | Grove      6682 | 3290 | 17.5 | 24 | 12 | 12 | 12 | 12 | 12 | 24 | 24 | 12 | 12 | 12 | 2 | 12 | 12 | 10
3436 |  |  | R122906 | R010107 | R020307 | R031107 | R031707 | A050407 | A062107 | R070907 | R071507 | R080207 | A081107 | A090707 | A092807 | A101907 | [NAME] | A111807
3436 | CUPO       7266 | 3160 | 24 | 24 | 24 | 24 | 24 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 24 | 12 | 12
3433 |  |  | R122906 | R021807 | R022407 | R031107 | R031707 | R051907 | R030607 | R062407 | R070907 | R071507 | [NAME] | A081407 | A082307 | R091607 | R101307 | R110907
3433 | Morrill       7098 | 3161 | 24 | 24 | 24 | 24 | 24 | 12 | 12 | 12 | 12 | 12 | 4 | 14 | 14 | 24 | 24 | 12
3265 |  |  | A081006 | A081606 | R090306 | R101506 | R110506 | A112906 | R120506 | R121706 | R122006 | R122606 | R122906 | R011307 | R020307 | R021807 | R022407 | R031107
3265 | Delatorre 7165 | 2959 | 12 | 12 | 24 | 24 | 24 | 12 | 18 | 12 | 24 | 24 | 24 | 12 | 12 | 24 | 24 | 24
3211 |  |  | R062606 | [NAME] | A081606 | A90306 | R092406 | A101506 | R102106 | R110506 | A112906 | A120206 | R120506 | R122606 | R010107 | R01307 | R020307 | R021807
3211 | SCHAK    7164 | 2935 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 24 | 12 | 24 | 24 | 24 | 24 | 12 | 12 | 24
3028 |  |  | A021706 | A022006 | A031006 | A032506 | R041806 | A051206 | A053006 | R060206 | A062906 | A070206 | A072906 | A081906 | A082506 | A091206 | A100606 | R102106
3028 | [NAME] | 2824 | 12 | 12 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
2921 |  |  | A032305 | R102905 | R110405 | R112805 | R121505 | R122505 | R123105 | R010306 | R021106 | R021406 | R022006 | R022606 | R030406 | R031606 | A042706 | R050606
2921 | WOLFE    7058 | 2693 | 0 | 24 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 24 | 12 | 12 | 24
2915.5 |  |  | A030905 | A031405 | A102305 | A102405 | A110405 | A112805 | R121605 | 122505 | A123105 | R012106 | A022006 | [NAME] | A031606 | A042706 | R050606 | R053006
2915.5 | ESTOPINAN 7060 | 2694 | 0 | 0 | 17 | 11 | 24 | 12 | 12 | 12 | 13.5 | 24 | 12 | 24 | 24 | 12 | 12 | 12
2826 |  |  | A022805 | A061005 | A071505 | A072205 | R072505 | A080605 | A082105 | A091705 | R110105 | R110405 | A032806 | A033106 | [NAME] | A040806 | A041206 | R041806
2826 | WEIHS     7020 | 2597 | 8 | 12 | 12 | 12 | 12 | 12 | 24 | 12 | 24 | 24 | 24 | 12 | 5 | 12 | 12 | 12
2824 |  |  | A052305 | A060705 | A062505 | A070705 | A080605 | A082405 | A090805 | A102005 | A110705 | A111005 | R111305 | A120105 | A122205 | A122505 | A010606 | R020506
2824 | LINHARES7018 | 2596 | 12 | 12 | 12 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 24 | 12 | 24 | 12 | 12 | 12
2821 |  |  | A021705 | A060705 | A062505 | A070405 | A071905 | A072505 | A080605 | A090505 | A100505 | A102305 | A102405 | A111305 | A120105 | A121905 | A122805 | R010906
2821 | GRIFFITH 7017 | 2595 | 12 | 12 | 12 | 6 | 12 | 12 | 12 | 12 | 12 | 17 | 11 | 24 | 12 | 12 | 24 | 24
2766 |  |  | R122004 | R122604 | R010105 | A052005 | A052605 | A061605 | A062805 | R070705 | R080605 | R082405 | A092905 | A100805 | R102905 | R110405 | R112205 | A121305
2766 | [NAME]          5935 | 2546 | 12 | 12 | 24 | 6 | 12 | 6 | 12 | 24 | 12 | 12 | 12 | 4 | 24 | 24 | 12 | 12
2744 |  |  | A010205 | A031205 | A032105 | A041405 | A050205 | A050505 | R050805 | A051105 | R070405 | R070705 | A072505 | R080605 | A083005 | R091705 | A102905 | R111305
2744 | Fox          7016 | 2497 | 24 | 24 | 12 | 12 | 12 | 6 | 12 | 13 | 12 | 24 | 12 | 12 | 12 | 12 | 24 | 24
2673 |  |  | A121804 | A022805 | A031205 | A040205 | A040505 | A041105 | [NAME] | R050205 | R050805 | A051105 | [NAME] | A070705 | R071005 | A072505 | A072805 | A081805
2673 | Sampson  7019 | 2496 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 5 | 12 | 12 | 12 | 12 | 12 | 4 | 12 | 12
2664 |  |  | A080704 | A101304 | A103104 | A112704 | R121804 | A022205 | A030605 | A031205 | A040805 | A042005 | A042905 | A050805 | A052005 | A062805 | A070405 | A072205
2664 | Christmas     6981 | 2440 | 24 | 7 | 12 | 12 | 12 | 12 | 12 | 24 | 12 | 12 | 12 | 13 | 12 | 12 | 12 | 24
2422.5 |  |  | A092204 | A100404 | A101304 | R102504 | R102804 | R103104 | R110304 | R110604 | A111504 | A112104 | A112404 | R112704 | A113004 | A120904 | [NAME] | A121504
2422.5 | Walsh      6218 | 2206 | 24 | 24 | 13 | 12 | 12 | 12 | 12 | 12 | 11 | 12 | 12.5 | 12 | 12 | 12 | 12 | 12
2422 |  |  | A072704 | R100404 | R101004 | A102804 | A110304 | A111504 | A111804 | A120304 | A121504 | R122104 | A122404 | A122704 | R123004 | A010205 | A010505 | A011405
2422 | [NAME]  6885 | 2205 | 24 | 12 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 13 | 12 | 12
2412 |  |  | A100404 | R100704 | R101004 | R101304 | R102804 | R110304 | R110604 | R111804 | R112104 | R112404 | A112704 | R113004 | R120904 | R121204 | R121804 | R122104
2412 | [NAME]     6960 | 2207 | 13 | 12 | 24 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
2170 |  |  | A010505 | A010805 | A011405 | A011505 | A012005 | 1012605 | A012905 | A020405 | R020705 | A021005 | A021905 | A021605 | A022505 | A052005 | [NAME] | R052605
2170 | Pierce    5723 | 1978 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
1655.5 |  |  | A032303 | A041603 | A041903 | A042503 | A042803 | A050703 | R051303 | A051903 | A052503 | R061503 | R062703 | A063003 | A070603 | R070903 | A071803 | A072103
1655.5 | Weidman  6794 | 1313 | 24 | 4 | 24 | 24 | 24 | 24 | 24 | 14 | 24 | 24 | 24 | 12.5 | 24 | 24 | 24 | 24
1227.5 |  |  | A081302 | A081602 | R083102 | A090902 | R092402 | A092702 | R093002 | R100602 | R101202 | R101802 | R110802 | A112902 | R112302 | [NAME] | R122302 | O11903
1227.5 | Graziose  6569 | 861 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 6.5 | 24 | 24 | 24 | 24
1211 |  |  | A04/15/02 | A05/06/02 | A05/21/02 | A05/27/02 | R05/30/02 | R06/02/02 | A071102 | R072602 | A081602 | A102402 | A102702 | R110802 | A120502 | R121102 | R122002 | A010103
1211 | SCOTT        7364 | 907 | 24 | 24 | 11 | 24 | 24 | 24 | 6 | 24 | 24 | 5 | 24 | 24 | 7 | 11 | 24 | 24
1173.5 |  |  | A01/12/01 | AO3/10/02 | A04/03/02 | A04/18/02 | [NAME] | [NAME] | A05/18/02 | A05/30/02 | A06/05/02 | A062902 | A093002 | R101202 | A112602 | A112302 | A120802 | A122302
1173.5 | SHELLY   6701 | 843 | 24 | 24 | 12 | 24 | 24 | 0 | 24 | 24 | 24 | 24 | 24 | 24 | 6.5 | 24 | 24 | 24
971 |  |  | A02/25/01 | R02/28/01 | A03/24/01 | A03/27/01 | R04/08/01 | A04/11/01 | A04/14/01 | A04/20/01 | R05/05/01 | R05/26/01 | V06/01/01 | R06/03/01 | R06/10/01 | R7/01/01 | R07/04/01 | R07/16/01
971 | BUCCILLI 6980 | 611 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 0 | 24 | 24 | 24 | 24 | 24
728 |  |  | A02/22/01 | A03/06/01 | A03/30/01 | A04/14/01 | R04/17/01 | A05/01/01 | A05/05/01 | R05/13/01 | R05/26/01 | A05/29/01 | A06/07/01 | A06/13/01 | A06/19/01 | R07/28/01 | A08/03/01 | A08/06/01
728 | [NAME] | 362 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 6 | 24 | 24
608.5 |  |  | R02/25/01 | R03/06/01 | A03/12/01 | R03/18/01 | R03/24/01 | R03/30/01 | U04/05/01 | U04/08/01 | R04/14/01 | R04/17/01 | R04/26/01 | A05/05/01 | A05/11/01 | R05/13/01 | A05/26/01 | R06/01/01
608.5 | Starcke   5458 | 284.5 | 24 | 24 | 24 | 24 | 24 | 24 | 0 | 0 | 24 | 24 | 24 | 24 | 12 | 24 | 24 | 24