Getting an average between two dates

[bacalaoyalcapurria]

I have two fields like

Beginning date ending date
4/13/2006 16:02:29 4/13/2006 16:03:05

I calculated the latency between the two fields by doing this,
=TEXT(J2-I2,"h:mm:ss")

Now, I'd like to get an average, but I can not seem to get it to work.

I tried to do something like this but it does not work,
=TEXT(Average(J2-I2,"h:mm:ss"))

Any idea?

Thanks,

Rita

 

[firefytr]

How does that not work?? What is the expected results?

-----------
Regards,
Zack Barresse

 

[bacalaoyalcapurria]

I get this error "You have enter too few arguments for this function

 

[firefytr]

Ah, syntax error. Try ..

=TEXT(Average(J2-I2),"h:mm:ss")

-----------
Regards,
Zack Barresse

 

[bacalaoyalcapurria]

Thanks.
I noticed I'm getting the same result as
=TEXT(J2-I2,"h:mm:ss")
for example,

Beginning Ending
4/13/2006 16:04:29 4/13/2006 16:05:05


Latency ( here I use =TEXT(J2-I2,"h:mm:ss")

0:00:36

Average ( here I'm using =TEXT(Average(J2-I2),"h:mm:ss")

0:00:36


Is that right?

 

[firefytr]

Change your - in the Average formula to a : sign. Woops, sorry I didn't catch it earlier.

-----------
Regards,
Zack Barresse

 

[mintjulep]

Average implies more than one number.

The difference between two numbers is only one number.

What is the meaning of the average of a time anyway?

 

[GlennUK]

Do you want to use average to find the mid-point between the beginning and end? That would give you:

4/13/2006 16:02:47

... is that what you want?

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[firefytr]

I believe that is what the OP wants Glenn. The issue is a character was wrong. It should have been the semi-colon and not the minus sign.

-----------
Regards,
Zack Barresse