Average / Time Difference on 2 Columns

[bwcampbell]

I am in need of advice / assistance

I have a table with 2 Columns showing times . I am trying to show in one cell the average difference of those two columns

I could create another column to show the difference for each row, and then average just that column .. but I would like to not have to add another column if possible.

The example looks like such, I would appreciate any assistance that can be offered

<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
[TD="class: xl66, width: 64"]REPT
[/TD]
[TD="class: xl66, width: 64"]NOTIF[/TD]

[TD="class: xl67"]23:59:52
[/TD]
[TD="class: xl67"]0:03:04[/TD]

[TD="class: xl65"]0:45:58[/TD]
[TD="class: xl65"]0:48:30[/TD]

[TD="class: xl67"]0:59:43[/TD]
[TD="class: xl67"]1:06:14[/TD]

[TD="class: xl65"]0:59:43[/TD]
[TD="class: xl65"]0:00:00[/TD]

</tbody>

 

[steve the fish]

I have a feeling there may be something better but this should work provided you have no empty cells:

=AVERAGE(IF(A2:A5>B2:B5,B2:B5-A2:A5+1,B2:B5-A2:A5))

Enter CTRL-SHIFT-ENTER

 

[steve the fish]

It could be written like this. Bit shorter

=AVERAGE(B2:B5-A2:A5+(A2:A5>B2:B5))

 

[bwcampbell]

Thats great I appreciate it

Is there any hope if I do have cells that are empty ?