Member Avatar for leviathan185

Hi All,

I have been doing a little VBA in excel and I am tring to work out how to add 2 hour {or any amount of time} to the current time.

Google has failed me in finding the answer, most of the things i have found is formulas but no VB code to do this.

I am sure this is verry simple but the answer evades me.

Thanks

  • 2 Contributors
  • 3 Replies
  • 200 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for leviathan185

I got it DateAdd("h", 2, Now)

Member Avatar for vb5prgrmr

You are probably just missing the keyword you need to search for leviathan... DateAdd is the keyword you are looking for...

Good Luck

Member Avatar for vb5prgrmr

Ah ya beat me to it... :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.