Spreadsheet: 377791d1424171195-l-sung-ber-formel-oder-vba-test-2-
Sheet: Tabelle1

 | Abwesenheit Zeit [h] | Abwesenheit Land |  |  | [NAME] |  |  |  |  |  |  |  | Auslösung Betrag [EURO]
 | 23.5 | Deutschland |  |  | Land |  | Länderkürzel | Stunden | [NAME] |  | Steuerfrei
 |  |  |  |  |  | dummy1 |  |  |  | dummy2
 |  |  |  |  | Deutschland | Deutschland | D | bis 6 [NAME]. | <6 | 5.999 | 0
 |  |  |  |  |  | Deutschland |  | 6-8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | Deutschland |  | 8-10 Std. | <10 | 9.999 | 12
 |  |  |  |  |  | Deutschland |  | 10-24 Std. | <24 | 23.999 | 12
 |  |  |  |  |  | Deutschland |  | 24 [NAME]. | 24 | 24 | 24
 |  |  |  |  | Belgien | Belgien | BE | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | Belgien |  | 8-24 Std. | <24 | 23.999 | 27
 |  |  |  |  |  | Belgien |  | 24 [NAME]. | 24 | 24 | 40
 |  |  |  |  | [NAME] | [NAME] | CH | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | [NAME] |  | 8-24 Std. | <24 | 23.999 | 32
 |  |  |  |  |  | [NAME] |  | 24 [NAME]. | 24 | 24 | 48
 |  |  |  |  | Italien | Italien | I | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | Italien |  | 8-24 Std. | <24 | 23.999 | 23
 |  |  |  |  |  | Italien |  | 24 [NAME]. | 24 | 24 | 34
 |  |  |  |  | Frankreich | Frankreich | F | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | Frankreich |  | 8-24 Std. | <24 | 23.999 | 29
 |  |  |  |  |  | Frankreich |  | 24 [NAME]. | 24 | 24 | 44
 |  |  |  |  | Niederlande | Niederlande | NL | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | Niederlande |  | 8-24 Std. | <24 | 23.999 | 31
 |  |  |  |  |  | Niederlande |  | 24 [NAME]. | 24 | 24 | 46
 |  |  |  |  | Österreich | Österreich | A | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | Österreich |  | 8-24 Std. | <24 | 23.999 | 24
 |  |  |  |  |  | Österreich |  | 24 [NAME]. | 24 | 24 | 36
 |  |  |  |  | [NAME] | [NAME] | PO | bis 8 Std. | <8 | 7.999 | 0
 |  |  |  |  |  | [NAME] |  | 8-24 Std. | <24 | 23.999 | 18
 |  |  |  |  |  | [NAME] |  | 24 [NAME]. | 24 | 24 | 27
 |  |  |  |  | Türkei | Türkei | T | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Türkei |  | 8-24 Std. | >8 <24 | 23.999 | 27
 |  |  |  |  |  | Türkei |  | 24 [NAME]. | =24 | 24 | 40
 |  |  |  |  | Spanien | Spanien | E | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Spanien |  | 8-24 Std. | >8 <24 | 23.999 | 20
 |  |  |  |  |  | Spanien |  | 24 [NAME]. | =24 | 24 | 29
 |  |  |  |  | Portugal | Portugal | P | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Portugal |  | 8-24 Std. | >8 <24 | 23.999 | 24
 |  |  |  |  |  | Portugal |  | 24 [NAME]. | =24 | 24 | 36
 |  |  |  |  | [NAME] | [NAME] | DA | bis 8 Std. | <=8 | 7.999 | 0
 |  |  |  |  |  | [NAME] |  | 8-24 Std. | >8 <24 | 23.999 | 40
 |  |  |  |  |  | [NAME] |  | 24 [NAME]. | =24 | 24 | 51
 |  |  |  |  | [NAME] | [NAME] | RO | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | [NAME] |  | 8-24 Std. | >8 <24 | 23.999 | 18
 |  |  |  |  |  | [NAME] |  | 24 [NAME]. | =24 | 24 | 27
 |  |  |  |  | Schweden | Schweden | SCH | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Schweden |  | 8-24 Std. | >8 <24 | 23.999 | 48
 |  |  |  |  |  | Schweden |  | 24 [NAME]. | =24 | 24 | 51
 |  |  |  |  | Slowakei | Slowakei | SL | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Slowakei |  | 8-24 Std. | >8 <24 | 23.999 | 16
 |  |  |  |  |  | Slowakei |  | 24 [NAME]. | =24 | 24 | 24
 |  |  |  |  | Tschechien | Tschechien | CZ | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Tschechien |  | 8-24 Std. | >8 <24 | 23.999 | 16
 |  |  |  |  |  | Tschechien |  | 24 [NAME]. | =24 | 24 | 24
 |  |  |  |  | Ungarn | Ungarn | U | bis 8 Std. | <=8 | 8 | 0
 |  |  |  |  |  | Ungarn |  | 8-24 Std. | >8 <24 | 23.999 | 20
 |  |  |  |  |  | Ungarn |  | 24 [NAME]. | =24 | 24 | 30