Adding time

[junkie8]

This if condition is only supposed to be executed if my aTime is 2 hours more than lastaTime.

Format of aTime and lastaTime is "06:30:00 AM" for example

If (CDate(aTime) + TimeValue("02:00:00")) >= CDate(lastaTime))
{
}

But the code in the if condition is executed even if it is not true. Can someone figure out what is wrong with the code?

 

[DougAJ4]

If (CDate(aTime) + TimeValue("02:00:00")) >= CDate(lastaTime))

That checks if aTime is no more than 2 hours less than lastaTime.

You need:

If (CDate(aTime) - TimeValue("02:00:00")) >= CDate(lastaTime)) then

...

Doug Jenkins

http://newtonexcelbach.wordpress.com/

 

[strongm]

DateDiff is your friend here