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

REPT	NOTIF
23:59:52	0:03:04
0:45:58	0:48:30
0:59:43	1:06:14
0:59:43	0:00:00

<colgroup><col style="width:48pt" width="64" span="2"> </colgroup><tbody>
</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 ?