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.