Hi,
I have two columns like this way.
<tbody>
</tbody>
Here the values are in seconds. I want to write a formula, which show the total duration of seconds of a and b.
For example: here total duration of a is = (160-102) + (250-222) = 86 seconds.
Please suggest me how to do it.
Thanks
I have two columns like this way.
a | 102 | 103 |
a | 135 | 136 |
a | 157 | 160 |
b | 189 | 191 |
b | 201 | 202 |
a | 222 | 223 |
a | 245 | 250 |
b | 290 | 292 |
<tbody>
</tbody>
Here the values are in seconds. I want to write a formula, which show the total duration of seconds of a and b.
For example: here total duration of a is = (160-102) + (250-222) = 86 seconds.
Please suggest me how to do it.
Thanks