Question from a novice user:

I found this post as I was trying to create (what to you all will seem very simple I am sure) a straight forward rule to create a live clock in a cell on a worksheet - using OnTime.Application.

I also want another cell on the same sheet that does a fixed timestamp for NOW - so that I can work out time difference that has occurred between the two cells for the purpose of conditional cell formatting.

The workbook has two sheets; "GSEP Codes sheet" and "sheet2". Problems presented;

I believe there is no live now formula that allows me to have a constantly refreshing clock for a single cell (i.e. can only be done using VBA).

Other issue is that using the NOW and OnTime application within the module will affect EVERY =NOW() formula and create as a live clock - whereas I only want it to create a live clock to the one cell and not all of them (see below script) - please can someone offer me some help to isolate the module to just affect cell N6 in "GSEP Codes sheet" but allow =NOW() with a static value in any other cell. Thank you :-

Sub Digital_Clock()

Dim wb As Workbook

Dim ws As Worksheet

Set wb = ActiveWorkbook

Set ws = Sheets("GSEP Codes sheet")

With ws

.Range("N6").NumberFormat = "hh:mm:ss"

.Range("N6").Value = Now

Application.OnTime Now + TimeValue("00:00:01"), "digital_clock"

End With

End Sub