Hi @Justin_Barrett!
when I used the formula at the top, the Mod formulas were showing many decimals, so I simply added the round formulas to ensure that there were no extra decimals showing.
Apologies if that came across negatively! Maybe this was so...
Took the base of this formula and made something that looks a little cleaner:
IF(ROUND(MOD({Duration}/60,60))<10,ROUNDDOWN({Duration}/3600,0)&":"&“0”&ROUND(MOD({Duration}/60,60)),IF(ROUND(MOD({Duration}/60,60))=60,ROUNDUP({Duration}/3600,0)&":"& “00”...