I am using FMP10 and trying to design a form that when you enter time started (1400) and Time ended (1800) the calculation will show the answer in 14 minuted increment. Example: Started at 1400 hours; ended at 1800 hours; time worked would be 16. So far, this is the calculation I have entered. I get the answer in hours, but wonder if it is possible to show how many "15 minute" increments there are.
If(GetAsNumber(Started) >24 ;24 -Started + Ended;If(GetAsNumber (Started) ≥ GetAsNumber (Ended);24 - Started + Ended; Ended - Started))