Link to home
Start Free TrialLog in
Avatar of ReneGe
ReneGeFlag for Canada

asked on

Filemaker Pro - Rounding time

Hi there,

I currently have Filemaker Pro 13 Adv

I need to make a formula to round time to its nearest hour quarter.

For example:
12h05 = 12h00
12h14 = 12h15
12h17 - 12h15
12h25 = 12h35
1h59 = 2h00
23h59 = 0h00 midnight of next day

Thanks for your help,
Rene
ASKER CERTIFIED SOLUTION
Avatar of Will Loving
Will Loving
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ReneGe

ASKER

Hi Will,

That's exactly what I needed.

Thanks mate :)