date and time

Try using the function = NOW() in two consecutive cells. Then format one of them as hh:mm and the other as date.
I hope it works

You can use the
=NOW() function in a cell and format the way you want it. But it only updates when the sheet is calculated.

HTH

Is there a way i can get them moving digitally for example the seconds moving and the time automatically when i open the spreadsheet the time is moving already.

thanx

Not sure why the system clock isn't sufficient, but this will put an updating clock in a cell:


can't remember where I got it...

paddy
This message was edited by PaddyD on 2003-01-06 19:33

Try the following.
It will, however, cause an irritating flicker of the cursor.

Put in the Workbook module :-

Private Sub Workbook_Open()
Range("A1").NumberFormat = "mm/dd/yy hh:mm:ss"
Call Clock
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call StopTimer
ActiveWorkbook.Saved = True
End Sub

Put in a normal module :-

Dim Timer As Date

Sub Clock()
Timer = Now + TimeValue("00:00:01")
Application.OnTime Timer, "Update"
End Sub

Sub Update()
Range("A1").Value = Now
Call Clock
End Sub

Sub StopTimer()
On Error Resume Next
Application.OnTime EarliestTime:=Timer, Procedure:="Update", Schedule:=False
End Sub

If you want to look into this further, have a look at "active_clock.zip" at :-
http://www.xl-logic.com/pages/vba.html

remembered where I got it:

http://www.mvps.org/dmcritchie/excel/datetime.htm

Asked for more instructions by PM:

1) Hit Alt + F11 (to open the VB editor).
2) Go to inster | module
3) Paste the following in the window that has just opened:


4) Note the following:

"Note the Worksheets(1). This indicates the first worksheet in your workbook. You might want to change that to a specific sheet such as Worksheets("Clock Sheet") or Worksheets("Sheet7") so as to not wipe out any sheet that just happens to have become the first sheet."

5) Run the clock by going to tools | macros | startclock. Stop it by running stop clock. (It would make sense to asisgn these 2 macros to buttons on the sheet).

However, as Ponsonby pointed out, having an effectively continuously running macro will make your cursor flicker. Not clear what improvement this is over, say, the system clock?

Paddy

You can use the =NOW() function