Have a look here:
https://contexturesblog.com/archives...otal-in-excel/
Together with what you have tried already, this might do the trick. As long as all your entries are in hours:minutes, just formatting the cell where you want the answer to appear as h:mm should leave you with something close to what you want.