EXCEL current Time

I think Dave is right, this is a link to what I found with a web search:

https://sites.google.com/site/excelforbeginners/Home/vba-codes/clock-with-automatic-refresh

I cannot vouch that it will do the exact task you want as I have not tested it, but maybe there are other examples on the web.

Obviously, you can easily insert the time with “Ctrl+Shift+;”

or you can enter the command “=now()” which gives you the date and time, clicking on formula – “Calculate Now” in the ribbon will update the value of any cell using the =now() formula, that’s the easiest way. Else it’s Macro’s/VBA.

Further to my earlier post:

1 On the Ribbon open up ‘Developer’ (you may have to add this with the customize ribbon command(right click on any title in the ribbon and click ‘customize the ribbon’) Select Macro Security and Enable(this step is entirely optional but if you want completely automatic you’ll need too).

2. In the desired cell enter =NOW()

3 Click on Macros

4 in Macro name enter a name for your macro ie. Auto_Open and click create.

5 delete everything in the macro box and replace with

Sub Auto_Open() (<- name of your macro)

(indent) calculate

End Sub

6 Save the macro exit macro editor, save the workbook as a macro-enabled workbook file then exit the workbook.

Reopen and the sheet should auto update the time

attached file contains macros duh! and was created using office 2016