I am working in a Nintex O365 Responsive Form. I want to calculate the Total Time for Project based on the Time Spent Per Task. The calculations for Time Spent Per Task are in a repeating section. I have a calculated value control for Time Spent Per Task. The formula is Minutes/60 + Hours. How can I get a grand total for all the Time Spent Per Task entries to appear in the Total Time for Project control?

Thank you.

Hi Marnita. Make sure that the "Total Time for Project" control is a Calculated Value control and not positioned inside the repeating section. Set the formula for the "Total Time for Project" control to

where ControlName is the name of your "Time Spent Per Task" control in the repeating section. That should sum up all the values of the "Time Spent Per Task" fields in the repeating section for a grand total.sum(ControlName)