Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the time stamp in VBA for EXCEL
I want to record current time (Hour-Minutes-Second) in
VBA.How to accomplish with VB code,use what system function call |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the time stamp in VBA for EXCEL
Hi Ji,
Try this, Sub TimeStamper() Range("A1").Value = Now Range("A1").NumberFormat = "H:MM AM/PM" End Sub Regards, Rocky McKinley "Ji Wenke" wrote in message ... I want to record current time (Hour-Minutes-Second) in VBA.How to accomplish with VB code,use what system function call |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the time stamp in VBA for EXCEL
Hi Ji,
Oops should have included ":SS" as below, Sub TimeStamper() Range("A1").Value = Now Range("A1").NumberFormat = "H:MM:SS AM/PM" End Sub Regards, Rocky McKinley "Ji Wenke" wrote in message ... I want to record current time (Hour-Minutes-Second) in VBA.How to accomplish with VB code,use what system function call |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to get the time stamp in VBA for EXCEL
On Wed, 13 Aug 2003 20:24:04 -0700, "Ji Wenke"
wrote in microsoft.public.excel.programming: I want to record current time (Hour-Minutes-Second) in VBA.How to accomplish with VB code,use what system function call I probably misunderstand the question, but doesn't: Hour(Now) & "-" & Minute(Now) & "-" & Second(Now) work for you? (Nit pick: the above might give unexpected results when its execution straddles midnight.) -- Michael Bednarek, IT Manager, Tactical Global Management Waterfront Pl, Brisbane 4000, Australia. "POST NO BILLS" http://mcmbednarek.tripod.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
remove time stamp from date in excel | Excel Worksheet Functions | |||
EXCEL GLOBAL DATE AND TIME STAMP | Excel Discussion (Misc queries) | |||
Add time and date stamp to Excel comments. | Excel Discussion (Misc queries) | |||
Time stamp in Excel Sheet | Excel Discussion (Misc queries) | |||
How do I make a time Stamp in excel? | Excel Discussion (Misc queries) |