Spreadsheet: 769341d1645478418-countif-two-digits-beyond-decimal-place-sample
Sheet: Sheet2

Employee | Resource clocked | Account | Type code | Allowed | Time taken | Rate ph | Ext price | Inv No | WIP No | Actual Date costed | RTS code | Serv code | Sale type | Fran | Job card No | SOCo
30 | 4 | z2222 | A | 1.3 | 1.3 | 110 | 143 | 22113910 | 61867 | 11/02/2022 | LAB | MEC | E | H | 105844 | 22
30 | 4 | z2222 | A | 1.2 | 1.2 | 110 | 132 | 22113910 | 61867 | 11/02/2022 | INV | MEC | E | H | 105844 | 22
25 | 6 | H2200 | A | 1.4 | 1.4 | 105 | 147 | 22113985 | 61974 | [NAME] | SER25 | SER | E | H | 105685 | 22
25 | C/D | z2222 | A | 1 | 1 | 0 | 0 | 22113986 | 61974 | [NAME] | C/D | MEC | E | H | 105685 | 22
25 | 6 | z2222 | A | 0.2 | 0.2 | 107 | 21.4 | 22113986 | 61974 | [NAME] | TYRE | MEC | E | H | 0 | 22
23 | 4 | H2200 | A | 1.5 | 1.5 | 86.5 | 129.75 | 22113932 | 62016 | 12/02/2022 | HSER12+ | SER | E | H | 105874 | 22
23 | 4 | z2222 | A | 0.9 | 0.9 | 86 | 77.4 | 22113933 | 62016 | 12/02/2022 | RBP | MEC | E | H | 0 | 22
25 | 7 | H2200 | A | 1 | 1 | 95.42 | 95.42 | 22113947 | 62189 | 14/02/2022 | HSER12 | MST | E | H | 105877 | 22
25 | C/D | H2200 | A | 1 | 1 | 0 | 0 | 22113947 | 62189 | 14/02/2022 | C/D | MST | E | H | 105877 | 22
30 | 3 | H2200 | A | 1.8 | 1.8 | 80.75 | 145.35 | 22113688 | 62215 | 01/02/2022 | SER50 | SER | E | H | 105673 | 22
30 | 6 | z2222 | A | 0.5 | 0.5 | 110.85 | 55.43 | 22113704 | 62261 | 01/02/2022 | AIRCON | MEC | E | H | 105715 | 22
30 | C/D | z2222 | A | 10.6 | 1 | 0 | 0 | 22113704 | 62261 | 01/02/2022 | C/D | MEC | E | H | 105715 | 22
30 | 3 | z2222 | A | 0.5 | 0.5 | 110 | 55 | 22113838 | 62299 | 08/02/2022 | LAB | MST | E | Z | 105796 | 22
30 | 3 | z2222 | A | 0.23 | 0.23 | 110 | 25.3 | 22113838 | 62299 | 08/02/2022 | SAN | MST | E | Z | 0 | 22
30 | 3 | z2222 | A | 0.25 | 0.25 | 80 | 20 | 22113838 | 62299 | 08/02/2022 | TYRE | MST | E | Z | 0 | 22
30 | 3 | z2222 | A | 0.3 | 0.3 | 110 | 33 | 22113838 | 62299 | 08/02/2022 | TRA | MST | E | Z | 0 | 22
23 | 7 | H2200 | A | 1.5 | 1.5 | 86 | 129 | 22113810 | 62306 | 07/02/2022 | HSER12+ | MST | E | H | 105785 | 22
23 | C/D | z2222 | A | 1 | 1 | 0 | 0 | 22113811 | 62306 | 07/02/2022 | C/D | MEC | E | H | 105785 | 22
23 | 10 | z2222 | A | 0.16 | 0.16 | 110 | 17.6 | 22113811 | 62306 | 07/02/2022 | SAN | MEC | E | H | 0 | 22
23 | 7 | z2222 | A | 0.5 | 0.5 | 110 | 55 | 22113811 | 62306 | 07/02/2022 | AIRCON | MEC | E | H | 0 | 22
23 | 7 | z2222 | A | 0.25 | 0.25 | 110 | 27.5 | 22113811 | 62306 | 07/02/2022 | TYRE | MEC | E | H | 0 | 22
23 | 7 | z2222 | A | 0.49 | 0.49 | 110 | 53.9 | 22113811 | 62306 | 07/02/2022 | TRA | MEC | E | H | 0 | 22
23 | 4 | z2222 | A | 1 | 1 | 110 | 110 | 22113884 | 62315 | 10/02/2022 | LAB | MEC | E | H | 105655 | 22
30 | 7 | H2200 | A | 1.6 | 1.6 | 81.36 | 130.18 | 22113978 | 62325 | [NAME] | SER375 | SER | E | H | 105901 | 22
23 | C/D | z2222 | A | 12.6 | 1 | 0 | 0 | 22113837 | 62371 | 08/02/2022 | C/D | MOT | E | H | 105797 | 22
23 | 3 | z2222 | A | 0.3 | 0.3 | 110 | 33 | 22113837 | 62371 | 08/02/2022 | TYRE | MOT | E | H | 0 | 22
25 | 6 | H2200 | A | 1.3 | 1.3 | 112.97 | 146.86 | 22114025 | 62381 | 16/02/2022 | SER50 | SER | E | H | 105922 | 22
25 | C/D | z2222 | A | 1 | 1 | 0 | 0 | 22114026 | 62381 | 16/02/2022 | C/D | MOT | E | H | 105922 | 22
25 | 6 | z2222 | A | 0.6 | 0.6 | 110 | 66 | 22114026 | 62381 | 16/02/2022 | AIRCON | MOT | E | H | 0 | 22
25 | 31 | z2222 | A | 0.22 | 0.22 | 110 | 24.2 | 22114026 | 62381 | 16/02/2022 | SAN | MOT | E | H | 0 | 22
25 | 3 | z2222 | A | 0.5 | 0.5 | 110 | 55 | 22114026 | 62381 | 16/02/2022 | TRA | MOT | E | H | 0 | 22
25 | 4 | H2200 | A | 1.5 | 1.5 | 99.7 | 149.55 | 22113723 | 62385 | 02/02/2022 | HSER12+ | SER | E | H | 105731 | 22
23 | C/D | z2222 | A | 1 | 1 | 0 | 0 | 22113726 | 62385 | 02/02/2022 | C/D | MOT | E | H | 105731 | 22
23 | 4 | z2222 | A | 0.05 | 0.05 | 110 | 5.5 | 22113726 | 62385 | 02/02/2022 | LAB | MOT | E | H | 0 | 22