View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com.nospam is offline
external usenet poster
 
Posts: 172
Default I have date I want time

Format(Time, "hh:mm:ss")

HTH
Paul
----------------------

Dim strtime As String
strtime = Format(Now, "yy-mm-dd ")

but that gives me the date and not the time, what do I need to do to
make this give me the current time?