can I use variables for the column value?

[aristosv]

In Google Sheets, I set the "Duration" option on column G (TimeDifferece)

1.png

Then I set =C2-B2 so the time difference is calculated between those 2 cells.

2.png

And this is the result, which works exactly how I want it.

3.png

My problem is that this =C2-B2 must come from a software integration platform. And the values C2 and B2 will become C3/B3, C4/B4 etc..
So I need to tell the integration platform what the value of the row is.

The C2 and B2 values in the screenshot below, must be variables representing the row number.

4.png

How can I tell the integration platform to use the correct row number?

I hope I explained it clearly. If not let me know.

[TMS]

Try using the formula

Please Login or Register  to view this content.

=row() returns the row number where the formula resides.

[aristosv]

that worked great, thanks

[TMS]

You're welcome. Thanks for the rep.