Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to write a macro to get the system time in excel 97
|
#2
|
|||
|
|||
Option Explicit
Sub testme() MsgBox Now MsgBox Date MsgBox Format(Now, "hh:mm:ss") End Sub Raj wrote: -- Dave Peterson |
#3
|
|||
|
|||
You can also use the formulas directly into the cell:
=Date() for Just the date =Now() for Date and time and =Now()-Date() for just the time "Raj" wrote: |
#4
|
|||
|
|||
From now on - Do NOT put your question in the subject line. Put a meaningful
subject line such as "sytem time" and ask your question in the BODY of the message. Sub gettime() MsgBox Time End Sub -- Don Guillett SalesAid Software "Raj" wrote in message ... |
#5
|
|||
|
|||
I suggest that we act politely, and instead of giving orders we orientate
people. :-) Have a nice day! "Don Guillett" wrote: From now on - Do NOT put your question in the subject line. Put a meaningful subject line such as "sytem time" and ask your question in the BODY of the message. Sub gettime() MsgBox Time End Sub -- Don Guillett SalesAid Software "Raj" wrote in message ... |
#6
|
|||
|
|||
We have been doing that in MANY posts and yet the problem persists. Those
that insist will probably not get much in the way of answers. -- Don Guillett SalesAid Software "Mexage" wrote in message ... I suggest that we act politely, and instead of giving orders we orientate people. :-) Have a nice day! "Don Guillett" wrote: From now on - Do NOT put your question in the subject line. Put a meaningful subject line such as "sytem time" and ask your question in the BODY of the message. Sub gettime() MsgBox Time End Sub -- Don Guillett SalesAid Software "Raj" wrote in message ... |
#7
|
|||
|
|||
Depends on what you are looking for as the system time.
VBA time functions Now, Time include truncated seconds. The VBA timer function about the same though it differs on PC and MAC PC version really only attempts to show seconds. (on a PC it show .0 or .5 seconds). The Excel NOW Worksheet Function is accurate to 10ms. For a comparison of the Date and Time worksheet functions to the VBA functions (I am using Excel 2000) see http://www.mvps.org/dmcritchie/excel...htm#comparison If you are interested in timing something see http://www.mvps.org/dmcritchie/excel/slowresp.htm#timer based on "How To Use QueryPerformanceCounter to Time Code" http://support.microsoft.com/kb/172338/EN-US/ --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Raj" wrote . (question was missing as already mentioned) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to write macro after autofilter is applied | Excel Worksheet Functions | |||
Running a macro at a certain time | Excel Discussion (Misc queries) | |||
automatically insert system time in a cell | Excel Discussion (Misc queries) | |||
How do I write a macro for... | Excel Discussion (Misc queries) | |||
Date and Time Macro | Excel Discussion (Misc queries) |