Turn seconds into mm.ss and save to db field

I have a field that stores seconds.

I need to calculate minutes and seconds from this and update a second field in the DB

example of the calculation below:

Divide 560 seconds by 60 to get 9.33333… Subtract the whole number (9) so you’re just left with the .33333… part. Multiply by that by 60 to get 20. Your answer is 9 minutes 20 seconds.

store 9.20 in the DB second field

can anyone help with this please?

Hi there, @artie717… here is an example where a text element is displaying the number of seconds entered into an input field as minutes and seconds.


Hope this helps.