1 Reply Latest reply on Oct 22, 2010 10:50 AM by philmodjunk

    Change Hours with Decimal to display Hours and Minutes

    AAgraphics

      Title

      Change Hours with Decimal to display Hours and Minutes

      Post

      FMP 10, Mac and PC

      I want a field to display "X Hours XX Minutes".  Currently, my calculation outputs "5.73 Hours".  My existing calculation is:

      ((Day01Exit05 - (If ( Day01Exit05 = "" ; "" ; Day01Entry05))) + (Day01Exit04 - (If ( Day01Exit04 = "" ; "" ; Day01Entry04))) + (Day01Exit03 - (If ( Day01Exit03 = "" ; "" ; Day01Entry03))) + (Day01Exit02 - (If (Day01Exit02 = "" ; "" ; Day01Entry02))) + (Day01Exit01 - (If ( Day01Exit01 = "" ; "" ; Day01Entry01))))/3600

      All the fields referenced in the calculation are timestamps.  Any simple modifications I can make to this script so it will display hours and minutes instead of hours with a decimal?