need to get average for the elapsed times

[Borko]

can someone look at this please I need to get average for the elapsed times??

I had to first convert the column to text...Im having such a bad day

please anyone!

[tigeravatar]

Borko,

Attached is a modified version of your posted workbook. In cell F2 and copied down, I used this formula (instead of the one you had):
=IF(D2<E2,"",D2-E2)

I then formatted those cells as custom "dd hh:mm:ss"
That made the cells display the desired information and remain numbers instead of text. Then, for the average (i used cell F11), is this formula:
=AVERAGE(F2:F9)

[Borko]

So how would I create a new formula for elapsed time fromcreation to first contact??

Borko,

Attached is a modified version of your posted workbook. In cell F2 and copied down, I used this formula (instead of the one you had):
=IF(D2<E2,"",D2-E2)

I then formatted those cells as custom "dd hh:mm:ss"
That made the cells display the desired information and remain numbers instead of text. Then, for the average (i used cell F11), is this formula:
=AVERAGE(F2:F9)

[ChemistB]

A couple of questions. In most cases you don't have anything in column E and your formula is =TEXT(D2-E2, "dd h:mm:ss").
Secondly, why did you need to format as text? Couldn't you have formatted the cell custom dd hh:mm:ss?

[Borko]

A couple of questions. In most cases you don't have anything in column E and your formula is =TEXT(D2-E2, "dd h:mm:ss").
Secondly, why did you need to format as text? Couldn't you have formatted the cell custom dd hh:mm:ss?

because that is the only way my formula would would is if I changed it to text

[tigeravatar]

Borko,

In cell B2 and copied down, format as custom "dd hh:mm:ss" (no quotes):
=IF(C2<A2,"",C2-A2)