Calculating time in two or more collections

[Einar]

Hi there

What is the best way to calculate time in two or more collections?

Regards. Einar

[Runcorn]

Hi @Einar,

By calculate time if you mean to sum them what you can do is,

sum(map(Data;hoursBilled))

and, do the same for the other.

[Einar]

HI Runcorn,

Thanks.

Do I have to use Tools Variable to Sum this.

I can’t use HTTP Request?

[Runcorn]

You can set those on where you want in Set a variable or if you are using it somewhere else you can just add that formula over there.

[Einar]

This give me error

[Einar]

Works.