Adding 15 minutes to a time variable in VBA

[jag108]

Hi, another one that is giving me a headache.

I am settting two values for DTPickers, one with DTPicker1.value = Format(now(), "hh:mm") as the value the other to be DTPicker.value = Format(DTPicker1.value + 15, "hh:mm") but I am getting no where fast.

The answer is probably so simple, but I just cant see it for the life of me...

Help!!! please

 

[agihcam]

try;

DTPicker.value = Format(DTPicker1.value + timevalue("00:15"), "hh:mm")

 

[jag108]

Hi agihcam,
the returned value is the same as the TimeValue = "00:15" so it did not actually add the 15 to the time already set.


Thanks for the assistance.

 

[agihcam]

it works with mine.

 

[Scott Huish]

Try this:

DTPicker = Format(TimeValue(DTPicker1) + TimeValue("00:15"), "hh:mm")

 

[jag108]

Sorted, thanks Guys!