Carl,

You can use the application.ontime method to have the times update at set
time intervals.

http://ForPicks.com

"carl" wrote:

IS there a function that I can have running in a cell that acts like a clock
- ticks every second ?

If so, can it be fomated so that an ajacent cell can add 30 seconds to the
clock time and round up to the next full minute. For example.

Time Time + 30 Seconds

9:32:22 AM 9:33:00 AM
9:32:45 AM 9:45:00 AM

Thank you in advance