[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]BehEvent[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="width: 54"]Time[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Lobtailing[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]21:11.2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow
[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]21:33.6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]22:21.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]22:36.3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Lobtailing[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]23:26.5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Lobtailing[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]23:30.6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]24:07.6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]24:29.8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Fluke Up Dive[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]24:50.9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would like help trying to create a formula to subtract the difference in time between the first blow and the last blow of the same sequence. So between Lobtailing and Lobtailing and between Lobtailing and Fluke Up Dive. So getting the difference between 21:33.6 - 22:36.3 and 24:07.6 - 24:29.8. Any ideas?
Thanks.
<tbody>[TR]
[TD][TABLE="width: 98"]
<tbody>[TR]
[TD="width: 98"]BehEvent[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="width: 54"]Time[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Lobtailing[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]21:11.2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow
[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]21:33.6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]22:21.7[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]22:36.3[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Lobtailing[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]23:26.5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Lobtailing[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]23:30.6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]24:07.6[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Blow[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]24:29.8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]Fluke Up Dive[/TD]
[TD][TABLE="width: 54"]
<tbody>[TR]
[TD="class: xl65, width: 54, align: right"]24:50.9[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would like help trying to create a formula to subtract the difference in time between the first blow and the last blow of the same sequence. So between Lobtailing and Lobtailing and between Lobtailing and Fluke Up Dive. So getting the difference between 21:33.6 - 22:36.3 and 24:07.6 - 24:29.8. Any ideas?
Thanks.