ReneGe
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That's exactly what I needed.
Thanks mate :)