LinkBack URL
About LinkBacks
Hello,
I'm looking for a way to display only the time? Is it possible?
Many thanks!
Please Login or Register to view this content.
Aquila
Hello,
I'm looking for a way to display only the time? Is it possible?
Many thanks!Please Login or Register to view this content.
Aquila
Last edited by Aquila; 11-21-2010 at 01:46 PM.
it's part of the standard VBA-library (VBEditor, F2, VBA)
Please Login or Register to view this content.
Last edited by snb; 11-20-2010 at 03:26 PM.
very nice snb, 1 step, but i still get date and time
Did you use F2 ?
Also in the VBA library:
Format
Formatdatetime
TimeValue
Timeserial
DatePart
Dive into their possibilities.
Hello Aquila,
You can by using the Format statement. I have added it to your code below.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
thnx Leith
solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks