Convert Seconds to h:mm in forumla

Jump to Solution
4871 10
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

I’m having trouble with something that seems very simple. I’d like where it says “0.9 available” for it to show that time formatted as “h:mm”, as it does in the “Time Available” field next to it.


Here the formula for the Name field:


Essentially I think I need to convert seconds to hours, minutes and seconds within a formula, but I can’t find a way to do it and feel I’m probably just missing something simple. Thanks so much.

10 Replies 10
7 - App Architect
7 - App Architect

Both formulas produce results like 4:6 or 6:0 when I hope to see 4:06 or 6:00.

How did you avoid those?

ROUNDDOWN({Time Available}/3600, 0)
& ":" & ROUND(({Time Available}/60) - (60*ROUNDDOWN({Time Available}/3600, 0)),0)

ROUNDDOWN(({Time Available}/3600), 0) & ":" & ROUND(MOD(({Time Available}/60), 60))

Update, used instead:

DATETIME_FORMAT(DATEADD(TODAY(),{Time Available}&"",'s'),'H:mm')