|
Einfaches Beispiel zur Arbeitszeitberechnung |
|
Tabelle4
| | A | B | C | D | E | F | G | | 1 | von | bis | Stunden | Lohn | | Lohn | 10,00 € | | 2 | 08:00 | 16:30 | 08:30 | 85,00 € | | | | | 3 | 14:00 | 21:00 | 07:00 | 70,00 € | | | | | 4 | 21:00 | 03:00 | 06:00 | 60,00 € | | | |
| Formeln der Tabelle | | Zelle | Formel | | C2 | =REST(B2-A2;1) | | D2 | =C2*$G$1*24 | | C3 | =REST(B3-A3;1) | | D3 | =C3*$G$1*24 | | C4 | =REST(B4-A4;1) | | D4 | =C4*$G$1*24 |
|
|
