Hello Wil
I can't help you out on VBA, but this may help you as well:
<table valign="middle" colspan="7" 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="28pt"><col width="60pt"><col width="47,25pt"><col width="47,25pt"><col width="47,25pt"><col width="134,25pt"><col width="114,75pt"></colgroup><tbody><tr style="background-color: rgb(250, 250, 250);"><td colspan="7" 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></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">1</td><td align="right">
</td><td align="left">days</td><td align="left">hours</td><td align="left">minutes</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">2</td><td align="right">27:59</td><td align="right">1</td><td align="right">3</td><td align="right">59</td><td align="right">
</td><td align="right">
</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">3</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">4</td><td align="right">
</td><td colspan="3" rowspan="1" align="middle">convert into decimal hours</td><td align="left">add up to a decimal value</td><td align="left">convert into serial time</td></tr><tr><td style="background-color: rgb(202, 202, 202);" align="middle">5</td><td align="right">
</td><td align="right">24</td><td align="right">3</td><td align="right">0,59</td><td align="right">27,59</td><td align="right">27:35</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="40pt"><col></colgroup><tbody><tr style="background-color: rgb(238, 170, 170);"><td>Zelle</td><td>Formel</td></tr><tr><td>B2</td><td>=DAY(A2)</td></tr><tr><td>C2</td><td>=HOUR(A2)</td></tr><tr><td>D2</td><td>=MINUTE(A2)</td></tr><tr><td>B5</td><td>=B2*24</td></tr><tr><td>C5</td><td>=C2</td></tr><tr><td>D5</td><td>=D2/100</td></tr><tr><td>E5</td><td>=SUM(B5:D5)</td></tr><tr><td>F5</td><td>=E5/24</td></tr></tbody></table><table style="font-family: Arial; font-size: 7pt;"><tbody><tr><td style="color: rgb(51, 51, 51);">Created and displayed with Tab2HTML (v2.4.1). ©Gerd alias Bamberg</td></tr></tbody></table>