0 Replies Latest reply on May 16, 2016 5:38 PM by ianm863305

    FormCalc Time Calculations

    ianm863305 Level 1


      I'm using the below formcalc script to calculate the difference from a start time to a finish time. What I want to see is something like:

      Start    Finish  Total

      1800    1932    1:32


      Using below I get the right amount of minutes but it always shows as a decimal for example 5mins would be .0833333 or 1 hour 5 mins = 1.0833333


      I have tried everything please help!


      $ = Abs(Time2Num(Row1.StartTime.formattedValue, "HH:MM") - Time2Num(Row3[0].EndTime.formattedValue, "HH:MM")) / (60*60*1000)


      Also if possible I need this to work past midnight for example:


      Start    Finish  Total

      2300    0118    2:18