Zelle | Formel |
G7 | =WENN(ISTLEER(D7); "";E7-F7-D7) |
H7 | =WENN(ISTLEER(E7); "";TEXT(ABS($K$7-G7); WENN(G7<$K$7;"-";)&"hh:mm")) |
G8 | =WENN(ISTLEER(D8); "";E8-F8-D8) |
H8 | =WENN(ISTLEER(E8); "";TEXT(ABS($K$7-G8); WENN(G8<$K$7;"-";)&"hh:mm")) |
G9 | =WENN(ISTLEER(D9); "";E9-F9-D9) |
H9 | =WENN(ISTLEER(E9); "";TEXT(ABS($K$7-G9); WENN(G9<$K$7;"-";)&"hh:mm")) |
G10 | =WENN(ISTLEER(D10); "";E10-F10-D10) |
H10 | =WENN(ISTLEER(E10); "";TEXT(ABS($K$7-G10); WENN(G10<$K$7;"-";)&"hh:mm")) |
G11 | =WENN(ISTLEER(D11); "";E11-F11-D11) |
H11 | =WENN(ISTLEER(E11); "";TEXT(ABS($K$7-G11); WENN(G11<$K$7;"-";)&"hh:mm")) |
G12 | =WENN(ISTLEER(D12); "";E12-F12-D12) |
H12 | =WENN(ISTLEER(E12); "";TEXT(ABS($K$7-G12); WENN(G12<$K$7;"-";)&"hh:mm")) |
G13 | =WENN(ISTLEER(D13); "";E13-F13-D13) |
H13 | =WENN(ISTLEER(E13); "";TEXT(ABS($K$7-G13); WENN(G13<$K$7;"-";)&"hh:mm")) |
G14 | =WENN(ISTLEER(D14); "";E14-F14-D14) |
H14 | =WENN(ISTLEER(E14); "";TEXT(ABS($K$7-G14); WENN(G14<$K$7;"-";)&"hh:mm")) |
G15 | =WENN(ISTLEER(D15); "";E15-F15-D15) |
H15 | =WENN(ISTLEER(E15); "";TEXT(ABS($K$7-G15); WENN(G15<$K$7;"-";)&"hh:mm")) |
G16 | =WENN(ISTLEER(D16); "";E16-F16-D16) |
H16 | =WENN(ISTLEER(E16); "";TEXT(ABS($K$7-G16); WENN(G16<$K$7;"-";)&"hh:mm")) |
G17 | =WENN(ISTLEER(D17); "";E17-F17-D17) |
H17 | =WENN(ISTLEER(E17); "";TEXT(ABS($K$7-G17); WENN(G17<$K$7;"-";)&"hh:mm")) |
G18 | =WENN(ISTLEER(D18); "";E18-F18-D18) |
H18 | =WENN(ISTLEER(E18); "";TEXT(ABS($K$7-G18); WENN(G18<$K$7;"-";)&"hh:mm")) |
G19 | =WENN(ISTLEER(D19); "";E19-F19-D19) |
H19 | =WENN(ISTLEER(E19); "";TEXT(ABS($K$7-G19); WENN(G19<$K$7;"-";)&"hh:mm")) |
G20 | =WENN(ISTLEER(D20); "";E20-F20-D20) |
H20 | =WENN(ISTLEER(E20); "";TEXT(ABS($K$7-G20); WENN(G20<$K$7;"-";)&"hh:mm")) |
G21 | =WENN(ISTLEER(D21); "";E21-F21-D21) |
H21 | =WENN(ISTLEER(E21); "";TEXT(ABS($K$7-G21); WENN(G21<$K$7;"-";)&"hh:mm")) |
G22 | =WENN(ISTLEER(D22); "";E22-F22-D22) |
H22 | =WENN(ISTLEER(E22); "";TEXT(ABS($K$7-G22); WENN(G22<$K$7;"-";)&"hh:mm")) |
G23 | =WENN(ISTLEER(D23); "";E23-F23-D23) |
H23 | =WENN(ISTLEER(E23); "";TEXT(ABS($K$7-G23); WENN(G23<$K$7;"-";)&"hh:mm")) |
G24 | =WENN(ISTLEER(D24); "";E24-F24-D24) |
H24 | =WENN(ISTLEER(E24); "";TEXT(ABS($K$7-G24); WENN(G24<$K$7;"-";)&"hh:mm")) |
G25 | =WENN(ISTLEER(D25); "";E25-F25-D25) |
H25 | =WENN(ISTLEER(E25); "";TEXT(ABS($K$7-G25); WENN(G25<$K$7;"-";)&"hh:mm")) |
G26 | =WENN(ISTLEER(D26); "";E26-F26-D26) |
H26 | =WENN(ISTLEER(E26); "";TEXT(ABS($K$7-G26); WENN(G26<$K$7;"-";)&"hh:mm")) |
G27 | =WENN(ISTLEER(D27); "";E27-F27-D27) |
H27 | =WENN(ISTLEER(E27); "";TEXT(ABS($K$7-G27); WENN(G27<$K$7;"-";)&"hh:mm")) |
G28 | =WENN(ISTLEER(D28); "";E28-F28-D28) |
H28 | =WENN(ISTLEER(E28); "";TEXT(ABS($K$7-G28); WENN(G28<$K$7;"-";)&"hh:mm")) |
G29 | =WENN(ISTLEER(D29); "";E29-F29-D29) |
H29 | =WENN(ISTLEER(E29); "";TEXT(ABS($K$7-G29); WENN(G29<$K$7;"-";)&"hh:mm")) |
G30 | =WENN(ISTLEER(D30); "";E30-F30-D30) |
H30 | =WENN(ISTLEER(E30); "";TEXT(ABS($K$7-G30); WENN(G30<$K$7;"-";)&"hh:mm")) |
G31 | =WENN(ISTLEER(D31); "";E31-F31-D31) |
H31 | =WENN(ISTLEER(E31); "";TEXT(ABS($K$7-G31); WENN(G31<$K$7;"-";)&"hh:mm")) |
G32 | =WENN(ISTLEER(D32); "";E32-F32-D32) |
H32 | =WENN(ISTLEER(E32); "";TEXT(ABS($K$7-G32); WENN(G32<$K$7;"-";)&"hh:mm")) |
G33 | =WENN(ISTLEER(D33); "";E33-F33-D33) |
H33 | =WENN(ISTLEER(E33); "";TEXT(ABS($K$7-G33); WENN(G33<$K$7;"-";)&"hh:mm")) |
G34 | =WENN(ISTLEER(D34); "";E34-F34-D34) |
H34 | =WENN(ISTLEER(E34); "";TEXT(ABS($K$7-G34); WENN(G34<$K$7;"-";)&"hh:mm")) |
G35 | =WENN(ISTLEER(D35); "";E35-F35-D35) |
H35 | =WENN(ISTLEER(E35); "";TEXT(ABS($K$7-G35); WENN(G35<$K$7;"-";)&"hh:mm")) |
G36 | =WENN(ISTLEER(D36); "";E36-F36-D36) |
H36 | =WENN(ISTLEER(E36); "";TEXT(ABS($K$7-G36); WENN(G36<$K$7;"-";)&"hh:mm")) |
G37 | =WENN(ISTLEER(D37); "";E37-F37-D37) |
H37 | =WENN(ISTLEER(E37); "";TEXT(ABS($K$7-G37); WENN(G37<$K$7;"-";)&"hh:mm")) |
H39 | =WENN(SUMMENPRODUKT((TEIL(H7:H37;2;99))*WENN(LINKS(H7:H37)="-";-1;1))<=0;"-";" ")&TEXT(ABS(SUMMENPRODUKT((TEIL(H7:H37;2;99))*WENN(LINKS(H7:H37)="-";-1;1))); "[hh]:mm") |
H41 | =November!H40+Dezember!H39 |