AnsweredAssumed Answered

How to round up time to hour.

Question asked by 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