Hello,

I would have been looking and cannot find a solution. But I am sure one of you can do it.

I have 2 columns (B and C) with times listed from Row 2 and will continue down several hundred rows. In a single cell, I would like to put a formula that will average the difference in the times in each row (the value will be in seconds... maybe minutes and seconds).

I tried to use this, but it didn't seem to work (Entered as an array):
=AVERAGE((C$2:C$65536-B$2:B$65536)*24*60*60)
Any help would be appreciated.

Thanks,

Mark