AnsweredAssumed Answered

How to round up time to hour.

Question asked by muhammad.ikram@contedia.com on Jun 19, 2018
Latest reply on Jun 19, 2018 by jbrown


Hello Community,

 

I thought this is easy but it turned out to be taking forever to resolve this.

 

I have a time field. I would like to round time up nearest to 1 hour ONLY IF THE TIME IS LESS THAN AN HOUR.

 

For Example: 00:23:12 -> This is 23 minutes; so I would like to be round up to 1 hour. so it would become 1.00.

 

I only want this to round up to 1 hour.

 

If the time is more than equal or more than an hour; it should stay same.

 

I looked at round and ceiling function in FileMaker; but they are not working.

 

Many Thanks

Outcomes