ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Now (https://www.excelbanter.com/excel-discussion-misc-queries/210659-now.html)

Ed

Now
 
How do I get =Now() to update every second?

--
Ed

muddan madhu

Now
 
custom format
dd-mm-yy h:mm:ss


On Nov 18, 9:02*am, Ed wrote:
How do I get =Now() to update every second?

--
Ed



Pecoflyer[_24_]

Now
 

Hav a look at 'this site' (http://www.cpearson.com/excel/OnTime.aspx)
the part about Windows Timers


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30821


Ed

Now
 
This really did not answer my question. I was looking for a digital clock.

Thanks for trying to help me out.
--
Ed


"Pecoflyer" wrote:


Hav a look at 'this site' (http://www.cpearson.com/excel/OnTime.aspx)
the part about Windows Timers


--
Pecoflyer

Cheers
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30821




All times are GMT +1. The time now is 10:45 AM.

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