View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gum Gum is offline
external usenet poster
 
Posts: 30
Default Adding Time to a variable in Excel VBA

I have a time string:
mytime= Format(Now(), "hh:mm:ss AMPM")
I need to add "00:00:40" to mytime
How can I do so and avoid mismatching.