Digital clock on excel

**shilpz** · 02-28-2008, 05:56 AM

hello

Is ther any way i can get a digital clock on excel that changes or updates every second, i know htere is a "=now()" function but this does not change per second

thanks in advance

**royUK** · 02-28-2008, 05:59 AM

See Andy's examples here

http://www.andypope.info/fun/clocks.htm

**shilpz** · 02-28-2008, 06:04 AM

thanks bro
thats what i want but i need it to be on a one individual cell

**dominicb** · 02-28-2008, 06:27 AM

Good morning shilpz

Format cell A1 to a time format of your choice then run this macro. It will update the cell every second :

Public CntTme As Double
Sub StartClock()
Sheets("Sheet1").Range("A1").Value = Now()
CntTme = Now + TimeSerial(0, 0, 1)
Application.OnTime CntTme, "'" & ThisWorkbook.Name & "'!StartClock", , True
End Sub

HTH

DominicB

**shilpz** · 02-28-2008, 06:37 AM

where do i copy the code to i dont understand it i formated the cell A! to time
ad pasted the forumula on a button but when i click the button

can you plz send it to me in a xls file plz

thanks in advance