Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 4192 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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!

Posted

Round(Seconds/60, 0)

 

Oh, you want it to always round up.

 

Case(

Seconds = 0, 0,

Int(Seconds/60) + 1

)

This topic is 4192 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.