Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
timer | Excel Discussion (Misc queries) | |||
Timer | Excel Discussion (Misc queries) | |||
Timer | Excel Worksheet Functions | |||
Lap-timer | Excel Discussion (Misc queries) | |||
Stopping a Timer / Running a timer simultaneously on Excel | Excel Discussion (Misc queries) |