If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Is there a formula for a timer
Is there a formula for a xcell that will count current time, IE display as a
clock or timer? |
#2
|
|||
|
|||
Is there a formula for a timer
Hi,
If you mean an updating digital clock then the answers no, you have to make your own. Alt+F11 to open VB editor. Right click 'This Workbook' and insert module and paste the code below in. Run the 'StartClock module and you get your clock in Sheet 1 - A1. Stop it manually when exiting Excel or better still put the StopClock sub in the before close event. Dim Go As Boolean Sub StartClock() Go = True MyClock End Sub Sub MyClock() If Go Then Worksheets("Sheet1").Cells(1, 1).Value = Format(Now, "hh:mm:ss") Application.OnTime (Now + TimeSerial(0, 0, 1)), "MyClock" End If End Sub Sub StopClock() Go = False End Sub Mike "1965cs" wrote: Is there a formula for a xcell that will count current time, IE display as a clock or timer? |
Thread Tools | |
Display Modes | |
|
|