Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Clock
I want to place a clock in a sheet. Attempts didn't work and in the helpfile
noticed that there should be a macro linked to the = ( ) function. This was no succes. Thanks in front. Marcel. |
#2
|
|||
|
|||
Marcel
I'm guessing you mean =NOW() ? That will put the current date and time in the cell. It will be updated every time the worksheet is recalculated. Try pressing F9 every so often to see the effect of forcing re-calculation. Format as hh:mm:ss to see just the time including seconds. Pressing F9 will also appear to be more effective or quicker or whatever. Regards Trevor "Marcel" wrote in message ... I want to place a clock in a sheet. Attempts didn't work and in the helpfile noticed that there should be a macro linked to the = ( ) function. This was no succes. Thanks in front. Marcel. |
#3
|
|||
|
|||
If you put:
=now() in a cell, it'll update whenever your worksheet recalculates -- not quite like a real clock, but pretty close. Personally, I just look at the clock in the taskbar. Marcel wrote: I want to place a clock in a sheet. Attempts didn't work and in the helpfile noticed that there should be a macro linked to the = ( ) function. This was no succes. Thanks in front. Marcel. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting 24-hour clock | Excel Worksheet Functions | |||
Time Clock | Excel Worksheet Functions | |||
how do i work out how many hrs have passed in a 24 hr clock, in ex | Excel Worksheet Functions | |||
Clock | Excel Worksheet Functions | |||
subtracting times using 24 hour clock | Excel Worksheet Functions |