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?

Time interval is counted as number of seconds, 15 minutes is 900 seconds, so

Ceiling ( ( end time - start time ) / 900 ) * 900

then set result as Time. And you want 4 hours as minimum result, calculation finally become

GetAsTime ( Max ( Time ( 4 ; 0 ; 0 ) ; Ceiling ( ( end time - start time ) / 900 ) * 900 ) )

//GetAsTime() is not need in field calculation, have another place to specify result data type