ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell showing the time auto updating (https://www.excelbanter.com/excel-discussion-misc-queries/73429-cell-showing-time-auto-updating.html)

M. Neves

Cell showing the time auto updating
 
How can I show ina a cell the system time, auto updating each second?

CLR

Cell showing the time auto updating
 
Are you sure you really want that? If you put this formula in a cell and
format for time, it will update every time the sheet
recalculates..........maybe that would do it for you..........

=NOW()

Vaya con Dios,
Chuck, CABGx3


"M. Neves" wrote:

How can I show ina a cell the system time, auto updating each second?


Niek Otten

Cell showing the time auto updating
 
http://www.mvps.org/dmcritchie/excel/datetime.htm#clock

--
Kind regards,

Niek Otten

"M. Neves" wrote in message
...
How can I show ina a cell the system time, auto updating each second?




M. Neves

Cell showing the time auto updating
 
Thanks for your help. That is enough.

M.

"Niek Otten" escreveu:

http://www.mvps.org/dmcritchie/excel/datetime.htm#clock

--
Kind regards,

Niek Otten

"M. Neves" wrote in message
...
How can I show ina a cell the system time, auto updating each second?






All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com