10 Replies Latest reply on Mar 21, 2016 7:14 AM by disabled_morkus

    Calculate hours from multiple fields

      I have a table called Request Schedules - which I would like to create a calculation field that adds up all of the fields, just numbers so 30 minutes would be (30) or 0.5 hours for each related request and show a value.

       

      Requests -------< Request Schedules

      pkRequestId -------< fkRequestId

       

      Request Schedules

      30 mins

      45 mins

      1 hour

      2 hours

      3 hours

      O/N (Overnight - 8 hours)