How to convert seconds into rounded minutes

[DLM]

Hi guys,

 

I'm using FM 5.5v1.

 

I've a field call "Seconds" that simply shows the amount of seconds like this:

 

88

23

268

409

 

I would like a calculation that converts them into rounded minutes, following with the above examples the calculation would convert them as follows:

 

2

1

5

7

 

What calculation should I use?

 

Best!

[DLM]

P.S. And if the Seconds are 0 (zero) then the calculation would also show 0.

[doughemi]

Round(Seconds/60, 0)

 

Oh, you want it to always round up.

 

Case(

Seconds = 0, 0,

Int(Seconds/60) + 1

)

[Lee Smith]

Int((Seconds + 59) / 60)