Hi everyone.
I have query on applying current time. when I use NOW() it gives me current time as well as current date. I just want the current time which I can get by using CTRL+SHIFT+;. But I would like to know the name of function which gives just current time as i need to build macro to insert only current time(not with current date). Or pleae let me know the macro code by which i can get only current time.
thank you
how about now() - today() ?
not a professional, just trying to assist.....
Hi Mangesh,Originally Posted by mangesh
Duane's formula will give you the correct time, but if this is for the code within a macro (to prevent the time from changing once assigned) then you will probably be better with
ActiveCell.Value = Now() - Int(Now)
hth
---
Si fractum non sit, noli id reficere.
Current time
try this sorry i am so late hope you can use this
Place =CT() in the cell you want the current time show
CODE
Function CT()
' return current time
CT = Time
End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks