AnsweredAssumed Answered

Change Hours with Decimal to display Hours and Minutes

Question asked by AAgraphics on Oct 22, 2010
Latest reply on Oct 22, 2010 by philmodjunk

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?

Outcomes