Hi Linda,

From your screenshot, it seems that your “time components” are nested inside a data grid. When working within a data grid, you’ll need to use the row variable instead of the data variable to access responses to other questions within the same row.

Using the data variable would cause your calculation to fail because it doesn’t specify which row in the data grid to reference. You likely noticed red lines under your expression, indicating an error.

Here’s the updated JavaScript code that should work:

TypeScript

const startDate = moment(row.startTime)\nconst endDate = moment(row.endTime)\n\nvalue = startDate.diff(endDate, 'hour')

Linda Babaic

Thanks so much :)

Linda Babaic

Linda Babaic

my next issue is trying to calculate all hours - anyone have any ideas? The script I am using is dropping all hours into the text field component - was wondering if there is a way to accumulate all hours??

Erin Dwyer

Hi Linda,

In your screen shot it looks like you are summing a bunch on text fields which is why you are getting a long string which is simply concatenating the text. In this specific scenario I think what you want is to calculate the total hours based on the start and end times of each row within a data-grid. We can achieve this with a JavaScript expression like the one below:

Note that you will need to adapt this JavaScript to match your specific form.

TypeScript

value = _.sumBy(data.dataGridRepeatingTable, (r) => {\n    const startDate = moment(r.startTime)\n    const endDate = moment(r.endTime)\n    return startDate.diff(endDate, 'hour')\n})

Linda Babaic

Hi Erin,

Thanks for the info, I was seeing if it was possible to tally up all hours in each row in a total box sitting out of the table - does that make sense??

Erin Dwyer

Hi Linda,

That’s what the example provided is trying to achieve. Though the expression may need to be adapted for your specific form.

I also suggest watching the video below which covers this topic :)

Team Forms Calculated Fields

calculate the hours between 2 time fields