1 Reply Latest reply on Nov 28, 2011 6:48 PM by LaRetta_1

    Time in minutes



      Time in minutes


      Hi Friends,

      Using FMP 10

      I have two time fields.  I want a third calculated field that shows the difference in minutes EVEN WHEN THE TIME DIFFERENCE IS GREATER THAN AN HOUR. i.e.  1hr 17min would show as "77"


      Specifically (I'm a newby) how do I do this.



        • 1. Re: Time in minutes

          Hi Sam,

          Create a calculation ( result is number ):

          Case (
          TimeIn and TimeOut ; // both time fields have a value before it will evaluate
          Div ( TimeOut -TimeIn  ; 60 )

          This is assuming you want to drop seconds entirely.  :-)