The result of either method is a time value. You can average it like you
can any time value. Just format the cell containing the average function as
time.

A time value is just a number less than 1, so it certainly be averaged.

This assumes the original values were actual date times.



--
Regards,
Tom Ogilvy

"Bill French" wrote in message
...
Tom, I would like to thank you for your input. Yes it worked! What I
failed to tell you and everyone else was that I needed to average the
column once I completed my task of getting just the time. Using the
format date or time, gave be a visual but would not allow me to do a
=average() and get a correct response.

I would also like to thank everyone else that viewed my posting and
provided input, I love this site.

Again thanks for the input and thanks to everyone else


Bill


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!