AnsweredAssumed Answered

Time Calculations

Question asked by Beary on Apr 22, 2010
Latest reply on Apr 22, 2010 by comment_1


Time Calculations


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))