How to Convert Seconds to Minutes with Hour Handling in Virtual Column?

I have a Virtual Column named [Embroidery Calc] with a data type set to “Duration.” This column displays the number of seconds, such as 120 seconds, which is equivalent to 2 minutes.
I want to convert these seconds into hours and minutes as “HH:MM

How can I accomplish this?

[Seconds]/60/60 & “:” & MOD( [Seconds]/60 , 60 )

1 Like