The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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”...
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.