I don't fully understand what you mean about "every 10 seconds", but
here is the general truth about times:
Times are numbers. If you can do something with a number, you can do
it with time, even if it doesn't make sense: AVERAGE, STANDARD
DEVIATION, MIN, MAX, ROUND, DIVIDE, etc.
...Except that time values cannot be negative numbers. If you do
something with time that results in negative, you get cell full of
#######.


--
wennerberg
------------------------------------------------------------------------
wennerberg's Profile: http://www.excelforum.com/member.php...fo&userid=7321
View this thread: http://www.excelforum.com/showthread...hreadid=471219