kylerjphillips

Calculate hours from multiple fields

Discussion created by kylerjphillips on Mar 21, 2016
Latest reply on Mar 21, 2016 by disabled_morkus

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)

 

Outcomes