1 Reply Latest reply on Apr 22, 2010 1:40 PM by comment_1

    Time Calculations

    Beary

      Title

      Time Calculations

      Post

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