Something like:

Sub RunClock()
Application.OnTime Now + TimeValue("00:00:01"), _
"UpdateClock"
End Sub

Sub UpdateClock()
Range("A1") = Time
RunClock
End Sub

I would recommend looking fo ranother approach, though, because this
involves a macro that runs every second and may interfere with other things
that you are trying to do in the workbook.

--

Vasant

"Wildman" wrote in message
...
Does anyone has a way to put a clock in a cell
that runs while the spreadsheets open?

is that possible?

(I've seen the awesome clock on Pearson's wonderful sight but I
just need a digital clock in one cell to calculate formulas in other
cells)

Thanks in advance

Wildman