Jim thanks for your response and advice, what you recommended is what I
tried yesterday. It gave me the time in the column but my next step was
to average and this time format would not allow me to average correctly.
I heard from Tom and he recommended the =int() and it worked and I was
able to average me column and get what I now believe is the correct
average.

Thanks for your input on my question.

Bill French



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