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

    Time in minutes

    amtrakpdx

      Title

      Time in minutes

      Post

      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.

       

      TIA

        • 1. Re: Time in minutes
          LaRetta_1

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