Spreadsheet: 153149d1335787387-excel-2007-vllookup-help-needed-quiz-2
Sheet: 04-2012

 |  |  |  |  |  |  |  |  | 01:00:00 | 08:00:00 | 17:00:00 |  | 01:00:00 | 08:30:00 | 19:00:00 |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  |  | 01:00:00 | 08:00:00 | 19:30:00 |  |  | 08:30:00 | 1900-01-01 00:00:00 |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  |  |  | 01:00:00 | 08:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  | 19:30:00
 |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | TAHAKKUK EDEN
 |  |  | id |  | GÖREVİ | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | TOPLAM MESAİ SAAT | worked days | WORKED HOURS | OVERTIME | SUNDAYS | HOLIDAY | [NAME] | [NAME] PAY | WORKED TIME PAY | OVERTIME PAY | SUNDAY PAY | HOLIDAY PAY | EXTRA PAY | INSIRUANCE | TOTAL SALARY | [NAME] | INSRUANCE | VAC | TOTAL | NET KALAN
 |  |  | 1117/ПС | mary | mechanic | 8 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 0 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 10 | 10 | 10.5 | 10.5 | 10.5 | 7.5 | 0 | 11 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 8 |  |  |  |  |  |  |  |  | 135 |  |  |  |  |  |  |  | 2500 | 3000
 |  |  |  |  | workedtime
 |  |  |  |  | overtime
 |  |  |  |  | Sunday | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | holiday
 |  |  | 1119/ПС | johny | mechanic | 8 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 0 | 0 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 10 | 10 | 10.5 | 10.5 | 10.5 | 7.5 | 0 | 11 | 10.5 | 10.5 | 10 | 10.5 | 10.5 | 8 |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  | 3000 | 3000
 |  |  |  |  | workedtime
 |  |  |  |  | overtime |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 8 |  |  | 10.5 | 10.5 | 10.5 | 8 |  | 10.5 | 10.5 | 10.5
 |  |  |  |  | Sunday | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | holiday
 |  |  | 1131/ПС | [NAME] | mechanic | 8 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 0 | 0 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 10 | 10 | 10.5 | 10.5 | 10.5 | 7.5 | 0 | 11 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 8 |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  | 2500 | 2500
 |  |  |  |  | workedtime
 |  |  |  |  | overtime |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 8 |  |  | 10.5 | 10.5 | 10.5 | 8 |  | 10.5 | 10.5 | 10.5
 |  |  |  |  | Sunday | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | holiday
 |  |  | 1135/ПС | [NAME] | MEKANİK  USTASI | 8 | 9.5 | 9.5 | 0 | 0 | 0 | 0 | 0 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 10 | 10 | 10.5 | 10.5 | 10.5 | 7.5 | 0 | 11 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 8 |  |  |  |  |  |  |  |  | 135 |  |  |  |  |  |  |  | 5000 | 5000
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 8 |  |  | 10.5 | 10.5 | 10.5 | 8 |  | 10.5 | 10.5 | 10.5
 |  |  |  |  | Pazar mesai | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | izinli hasta
 |  |  | T1213-C | BAYRAM SARI | mechanic |  |  |  |  |  |  |  |  | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 9.5 | 8 | 10 | 10 | 10.5 | 10.5 | 10.5 | 7.5 | 0 | 11 | 10.5 | 10.5 | 10.5 | 10.5 | 10.5 | 8 |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  | 4000 | 4000
 |  |  |  |  | workedtime
 |  |  |  |  | overtime |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 10.5
 |  |  |  |  | Sunday | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | holiday
 |  |  | T1213-C | [NAME] | mechanic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 10.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  | 3000 | 3000
 |  |  |  |  | workedtime
 |  |  |  |  | overtime
 |  |  |  |  | Sunday | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | holiday
 |  |  | T1213-C | maryln | mechanic |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 120 |  |  |  |  |  |  |  | 3000 | 3000
 |  |  |  |  | workedtime
 |  |  |  |  | overtime
 |  |  |  |  | Sunday | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5 |  |  |  |  |  |  | 7.5
 |  |  |  |  | holiday