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

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

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

Good Luck

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.