Help

Convert Seconds to h:mm in forumla

Solved
Jump to Solution
4871 10
cancel
Showing results for 
Search instead for 
Did you mean: 
LouD82
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.

image

Here the formula for the Name field:

image

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