Time

[Zimbozubble]

This probably sounds really silly but how can I increase a time value whilst maintaining the time rules (60 mins per hour). I noticed that I can do:

Date + 7

without any problems but it won't do:

Time + 30

Help, please!!!!

[Clearcode]

Assuming you mean in a VB date variable, use:

Dim dtNew as date
Dim dtOld as date

dtOld = Now()

dtNew = DateAdd("n",30,dtOld)





where "h" =hours, "n" = minutes, "s" = seconds

HTH,
Duncan

-------------------------------------------------
Ex. Datis: Duncan Jones
Merrion Computing Ltd
http://www.merrioncomputing.com

[Zimbozubble]

Excellent!! Thank you very much!!