Average of two sets of dates

  • Thread starter Thread starter Jeff Kerber
  • Start date Start date
J

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
 
One way, with dates out in column B:

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

HTH
Jason
Atlanta, GA
 
Simply subtract the averages of the columns, e.g.
=average(b1:b100)-average(a1:a100)
 
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
Click to expand...

*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
 
Just use Dave's formula. It'll ignore text and empty cells.

HTH
Jason
Atlanta, GA
 
Back
Top