AnsweredAssumed Answered

Time Calculation Question

Question asked by tap4pat on Nov 12, 2018
Latest reply on Nov 13, 2018 by Jason Wood

Hi, my name is Pat. I relatively new to Filemaker and the Community. I have a start time and an end time. I have a calculation field that gives me the time difference. I have a calculation that if the time difference is less than 4 hours the person is given credit for 4 hours, if it is greater than 4 hours they get that time rounded off to the next 15 minutes. My problem is that now, on paper, we round off to the next 15 minutes. For instance if the job was 4 hours and two minutes we round to 4 hours 15 minutes. Likewise 4 hours and 25 minutes is 4 hours and 30 minutes. How do I use the calculation functions to do this?