| Zelle | Formel |
| D5 | =WENN(ISTFEHLER((60/C5)); "";(60/C5)*B5) |
| E5 | =WENN(D5="";0;D5/1440) |
| F5 | =B5*C5 |
| J5 | =WENN(ISTFEHLER((60/I5)); "";(60/I5)*H5) |
| K5 | =WENN(J5="";0;J5/1440) |
| D6 | =WENN(ISTFEHLER((60/C6)); "";(60/C6)*B6) |
| E6 | =WENN(D6="";0;D6/1440) |
| F6 | =B6*C6 |
| J6 | =WENN(ISTFEHLER((60/I6)); "";(60/I6)*H6) |
| K6 | =WENN(J6="";0;J6/1440) |
| D7 | =WENN(ISTFEHLER((60/C7)); "";(60/C7)*B7) |
| E7 | =WENN(D7="";0;D7/1440) |
| F7 | =B7*C7 |
| J7 | =WENN(ISTFEHLER((60/I7)); "";(60/I7)*H7) |
| K7 | =WENN(J7="";0;J7/1440) |
| D8 | =WENN(ISTFEHLER((60/C8)); "";(60/C8)*B8) |
| E8 | =WENN(D8="";0;D8/1440) |
| F8 | =B8*C8 |
| J8 | =WENN(ISTFEHLER((60/I8)); "";(60/I8)*H8) |
| K8 | =WENN(J8="";0;J8/1440) |
| D9 | =WENN(ISTFEHLER((60/C9)); "";(60/C9)*B9) |
| E9 | =WENN(D9="";0;D9/1440) |
| F9 | =B9*C9 |
| J9 | =WENN(ISTFEHLER((60/I9)); "";(60/I9)*H9) |
| K9 | =WENN(J9="";0;J9/1440) |
| D10 | =WENN(ISTFEHLER((60/C10)); "";(60/C10)*B10) |
| E10 | =WENN(D10="";0;D10/1440) |
| F10 | =B10*C10 |
| J10 | =WENN(ISTFEHLER((60/I10)); "";(60/I10)*H10) |
| K10 | =WENN(J10="";0;J10/1440) |
| D11 | =WENN(ISTFEHLER((60/C11)); "";(60/C11)*B11) |
| E11 | =WENN(D11="";0;D11/1440) |
| F11 | =B11*C11 |
| J11 | =WENN(ISTFEHLER((60/I11)); "";(60/I11)*H11) |
| K11 | =WENN(J11="";0;J11/1440) |
| D12 | =WENN(ISTFEHLER((60/C12)); "";(60/C12)*B12) |
| E12 | =WENN(D12="";0;D12/1440) |
| F12 | =B12*C12 |
| J12 | =WENN(ISTFEHLER((60/I12)); "";(60/I12)*H12) |
| K12 | =WENN(J12="";0;J12/1440) |
| D13 | =WENN(ISTFEHLER((60/C13)); "";(60/C13)*B13) |
| E13 | =WENN(D13="";0;D13/1440) |
| F13 | =B13*C13 |
| J13 | =WENN(ISTFEHLER((60/I13)); "";(60/I13)*H13) |
| K13 | =WENN(J13="";0;J13/1440) |
| D14 | =WENN(ISTFEHLER((60/C14)); "";(60/C14)*B14) |
| E14 | =WENN(D14="";0;D14/1440) |
| F14 | =B14*C14 |
| J14 | =WENN(ISTFEHLER((60/I14)); "";(60/I14)*H14) |
| K14 | =WENN(J14="";0;J14/1440) |
| D15 | =WENN(ISTFEHLER((60/C15)); "";(60/C15)*B15) |
| E15 | =WENN(D15="";0;D15/1440) |
| F15 | =B15*C15 |
| J15 | =WENN(ISTFEHLER((60/I15)); "";(60/I15)*H15) |
| K15 | =WENN(J15="";0;J15/1440) |
| D16 | =WENN(ISTFEHLER((60/C16)); "";(60/C16)*B16) |
| E16 | =WENN(D16="";0;D16/1440) |
| F16 | =B16*C16 |
| J16 | =WENN(ISTFEHLER((60/I16)); "";(60/I16)*H16) |
| K16 | =WENN(J16="";0;J16/1440) |
| D17 | =WENN(ISTFEHLER((60/C17)); "";(60/C17)*B17) |
| E17 | =WENN(D17="";0;D17/1440) |
| F17 | =B17*C17 |
| J17 | =WENN(ISTFEHLER((60/I17)); "";(60/I17)*H17) |
| K17 | =WENN(J17="";0;J17/1440) |
| D18 | =WENN(ISTFEHLER((60/C18)); "";(60/C18)*B18) |
| E18 | =WENN(D18="";0;D18/1440) |
| F18 | =B18*C18 |
| J18 | =WENN(ISTFEHLER((60/I18)); "";(60/I18)*H18) |
| K18 | =WENN(J18="";0;J18/1440) |
| D19 | =WENN(ISTFEHLER((60/C19)); "";(60/C19)*B19) |
| E19 | =WENN(D19="";0;D19/1440) |
| F19 | =B19*C19 |
| J19 | =WENN(ISTFEHLER((60/I19)); "";(60/I19)*H19) |
| K19 | =WENN(J19="";0;J19/1440) |
| D20 | =WENN(ISTFEHLER((60/C20)); "";(60/C20)*B20) |
| E20 | =WENN(D20="";0;D20/1440) |
| F20 | =B20*C20 |
| J20 | =WENN(ISTFEHLER((60/I20)); "";(60/I20)*H20) |
| K20 | =WENN(J20="";0;J20/1440) |
| D21 | =WENN(ISTFEHLER((60/C21)); "";(60/C21)*B21) |
| E21 | =WENN(D21="";0;D21/1440) |
| F21 | =B21*C21 |
| J21 | =WENN(ISTFEHLER((60/I21)); "";(60/I21)*H21) |
| K21 | =WENN(J21="";0;J21/1440) |
| D22 | =WENN(ISTFEHLER((60/C22)); "";(60/C22)*B22) |
| E22 | =WENN(D22="";0;D22/1440) |
| F22 | =B22*C22 |
| J22 | =WENN(ISTFEHLER((60/I22)); "";(60/I22)*H22) |
| K22 | =WENN(J22="";0;J22/1440) |
| D23 | =WENN(ISTFEHLER((60/C23)); "";(60/C23)*B23) |
| E23 | =WENN(D23="";0;D23/1440) |
| F23 | =B23*C23 |
| J23 | =WENN(ISTFEHLER((60/I23)); "";(60/I23)*H23) |
| K23 | =WENN(J23="";0;J23/1440) |
| D24 | =WENN(ISTFEHLER((60/C24)); "";(60/C24)*B24) |
| E24 | =WENN(D24="";0;D24/1440) |
| F24 | =B24*C24 |
| J24 | =WENN(ISTFEHLER((60/I24)); "";(60/I24)*H24) |
| K24 | =WENN(J24="";0;J24/1440) |
| B25 | =SUMME(B5:B24) |
| C25 | =F25/B25 |
| D25 | =SUMME(D5:D24) |
| E25 | =WENN(D25="";0;D25/1440) |
| F25 | =SUMME(F5:F24) |
| H25 | =SUMME(H5:H24) |
| I25 | =L25/H25 |
| J25 | =SUMME(J5:J24) |
| K25 | =WENN(J25="";0;J25/1440) |