Average of two sets of dates

[Jeff Kerber]

I have a spreadsheet with two columns that are basically dates in and dates
out.

Is there a way to come up with the average time between those two columns
without creating a third colum to calculate the difference between each
individual date?

I hope that makes sense!

TIA,

Jeff

 

[Jason Morin]

One way, with dates out in column B:

=SUMPRODUCT(AVERAGE(B1:B12-A1:A12))

HTH
Jason
Atlanta, GA

 

[Dave R.]

Simply subtract the averages of the columns, e.g.
=average(b1:b100)-average(a1:a100)

 

[Ron Rosenfeld]

I have a spreadsheet with two columns that are basically dates in and dates
out.

Is there a way to come up with the average time between those two columns
without creating a third colum to calculate the difference between each
individual date?

I hope that makes sense!

TIA,

Jeff

*Array-entered* =AVERAGE(DateOut - DateIn)

To array-enter a formula, hold down <ctrl><shift> while hitting <enter>. XL
will place braces {...} around the formula.


--ron

 

[Jeff Kerber]

Small curve, I forgot that some of the cells will be empty or null.

Thanks.

 

[Jason Morin]

Just use Dave's formula. It'll ignore text and empty cells.

HTH
Jason
Atlanta, GA