Here is my guesswork:
<table valign="middle" colspan="20" style="font-family: Calibri; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-size: 11px; font-weight: normal; font-style: normal;" border="1" cellpadding="2" cellspacing="0"><colgroup><col width="28"><col width="23"><col width="29"><col width="32"><col width="15"><col width="39"><col width="29"><col width="32"><col width="15"><col width="39"><col width="29"><col width="32"><col width="15"><col width="39"><col width="29"><col width="32"><col width="15"><col width="39"><col width="105"><col width="78"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="20" align="middle">Arbeitsblatt mit dem Namen 'Tabelle1'</td></tr><tr style="background-color: rgb(202, 202, 202);"><td>
</td><td align="middle">A</td><td align="middle">B</td><td align="middle">C</td><td align="middle">D</td><td align="middle">E</td><td align="middle">F</td><td align="middle">G</td><td align="middle">H</td><td align="middle">I</td><td align="middle">J</td><td align="middle">K</td><td align="middle">L</td><td align="middle">M</td><td align="middle">N</td><td align="middle">O</td><td align="middle">P</td><td align="middle">Q</td><td align="middle">AL</td><td align="middle">AM</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td style="background-color: rgb(255, 255, 204);" align="left">Day</td><td style="background-color: rgb(255, 255, 204);" align="right">1</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">2</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">3</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">4</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="left">Daily Total (Hrs:Mins)</td><td style="background-color: rgb(255, 255, 204);" align="left">Daily Total (Hrs)</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="left">Time</td><td style="background-color: rgb(255, 255, 204);" align="left">Mode</td><td style="background-color: rgb(255, 255, 204);" align="left">FT</td><td style="background-color: rgb(255, 255, 204);" align="left">Reason</td><td style="background-color: rgb(255, 255, 204);" align="left">Time</td><td style="background-color: rgb(255, 255, 204);" align="left">Mode</td><td style="background-color: rgb(255, 255, 204);" align="left">FT</td><td style="background-color: rgb(255, 255, 204);" align="left">Reason</td><td style="background-color: rgb(255, 255, 204);" align="left">Time</td><td style="background-color: rgb(255, 255, 204);" align="left">Mode</td><td style="background-color: rgb(255, 255, 204);" align="left">FT</td><td style="background-color: rgb(255, 255, 204);" align="left">Reason</td><td style="background-color: rgb(255, 255, 204);" align="left">Time</td><td style="background-color: rgb(255, 255, 204);" align="left">Mode</td><td style="background-color: rgb(255, 255, 204);" align="left">FT</td><td style="background-color: rgb(255, 255, 204);" align="left">Reason</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td><td style="background-color: rgb(255, 255, 204);" align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">4</td><td align="right">1</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td style="background-color: rgb(204, 255, 204);" align="left">CG</td><td align="right">00:00</td><td align="left">Start</td><td align="left">G</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">6</td><td style="background-color: rgb(204, 255, 204);" align="left">DB</td><td align="right">00:00</td><td align="left">Start</td><td align="left">G</td><td align="right">
</td><td align="right">06:09</td><td align="left">Stop</td><td align="left">G</td><td align="right">4</td><td align="right">08:39</td><td align="left">Start</td><td align="left">G</td><td align="right">2</td><td align="right">12:10</td><td align="left">Stop</td><td align="left">G</td><td align="right">4</td><td style="font-weight: bold;" align="right">09:40</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">9,67</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">7</td><td style="background-color: rgb(204, 255, 204);" align="left">AX1</td><td align="right">00:00</td><td align="left">Run</td><td align="left">G</td><td align="right">
</td><td align="right">04:05</td><td align="left">Stop</td><td align="left">G</td><td align="right">
</td><td align="right">05:05</td><td align="left">Start</td><td align="left">G</td><td align="right">
</td><td align="right">13:30</td><td align="left">Stop</td><td align="left">G</td><td align="right">
</td><td style="font-weight: bold;" align="right">12:30</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">12,50</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">8</td><td style="background-color: rgb(204, 255, 204);" align="left">Ax2</td><td align="right">00:00</td><td align="left">Run</td><td align="left">G</td><td align="right">
</td><td align="right">05:00</td><td align="left">Stop</td><td align="left">G</td><td align="right">
</td><td align="right">18:45</td><td align="left">Start</td><td align="left">G</td><td align="right">
</td><td align="right">
</td><td align="left">Stop</td><td align="left">G</td><td align="right">
</td><td style="font-weight: bold;" align="right">05:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">5,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">9</td><td style="background-color: rgb(204, 255, 204);" align="left">KX</td><td align="right">00:04</td><td align="left">Run</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">10</td><td align="right">2</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">11</td><td style="background-color: rgb(204, 255, 204);" align="left">CG</td><td align="right">04:10</td><td align="left">Start</td><td align="left">G</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">12</td><td style="background-color: rgb(204, 255, 204);" align="left">DB</td><td align="right">08:30</td><td align="left">Start</td><td align="left">G</td><td align="right">
</td><td align="right">21:35</td><td align="left">Stop</td><td align="left">G</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">13:05</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">13,08</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">13</td><td style="background-color: rgb(204, 255, 204);" align="left">AX1</td><td align="right">00:00</td><td align="left">Run</td><td align="left">G</td><td align="right">
</td><td align="right">04:55</td><td align="left">Stop</td><td align="left">G</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">04:55</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">4,92</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">14</td><td style="background-color: rgb(204, 255, 204);" align="left">Ax2</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">15</td><td style="background-color: rgb(204, 255, 204);" align="left">KX</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td style="font-weight: bold;" align="right">00:00</td><td style="color: rgb(0, 128, 0); font-weight: bold;" align="right">0,00</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">16</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">17</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">18</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="left">Total</td><td align="right">45:10</td><td align="right">45,17</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">19</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="left">CG</td><td align="right">00:00</td><td align="right">0</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">20</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="right">
</td><td align="left">DB</td><td align="right">22:45</td><td align="right">22,75</td></tr></tbody></table>
<table valign="middle" colspan="3" style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><tbody><tr style="background-color: rgb(170, 238, 170);"><td>Zelle</td><td>Format</td><td align="right">Wert</td></tr><tr><td>AL18</td><td>[hh]:mm</td><td align="right">1,88194444444444</td></tr><tr><td>AL19</td><td>[hh]:mm</td><td align="right">0</td></tr><tr><td>AL20</td><td>[hh]:mm</td><td align="right">0,947916666666667</td></tr></tbody></table>
<table valign="middle" colspan="2" style="table-layout: auto; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255); font-family: Calibri; font-size: 10px;" border="3" cellpadding="2" cellspacing="0"><colgroup><col width="40"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Zelle</td><td>Formel</td></tr><tr><td>AL4</td><td>=SUM(IF(AND(B4<>"",F4<>""),F4-B4,0),IF(AND(J4<>"",N4<>""),N4-J4,0))</td></tr><tr><td>AM4</td><td>=AL4*24</td></tr><tr><td>AL18</td><td>=SUM(AL4:AL15)</td></tr><tr><td>AM18</td><td>=SUM(AM4:AM15)</td></tr><tr><td>AL19</td><td>=SUMPRODUCT(($A$4:$A$15=$Q19)*(AL$4:AL$15))</td></tr><tr><td>AM19</td><td>=SUMPRODUCT(($A$4:$A$15=$Q19)*(AM$4:AM$15))</td></tr></tbody></table>