Convert duration (mm:ss) into seconds

[LouD82]

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.

[Ricardo]

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')