Time in Spread Sheets

theres vba which will put time in a cell is that what you mean?
in a standard module

Dim SchedRecalc As Date
Sub Recalc()
Range("C3").Value = Format(Now, "dd-mmm-yy")
Range("C4").Value = Format(Time, "hh:mm:ss AM/PM")

Call SetTime
End Sub

Sub SetTime()
SchedRecalc = Now + TimeValue("00:00:01")
Application.OnTime SchedRecalc, "Recalc"
End Sub

Sub Disable()
On Error Resume Next
Application.OnTime EarliestTime:=SchedRecalc, Procedure:="Recalc", Schedule:=False
End Sub

then in this workbook

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Disable
End Sub

Private Sub Workbook_Open()
SetTime
End Sub

this will put date /time in c4/c3 of all sheets. but it is not very efficient as its constantly running /updating i tried to pin it to one sheet but then thats all it does it jumps to that on every update. there must be a better way

I was wondering if there is any formulas for putting a working clock on an excel spread sheet so that its on view all the time and works like a normal clock?

IMO, that's a very bad idea. For one thing, it kills Undo. What's wrong with the clock on the taskbar?

Hi,

I wonder why nobody suggested


=NOW()


Worksheet function.