Add minutes to starttime in msaccess vba code

Question

Hello,

I have a starttime and would like to add minutes to get an endtime.

examaple starttime : 2016-09-05 08:00:00.000 + 75 = 2016-09-05 09:15:00.000 (=endtime)

Thanks in advance.

Regards,

Ralph.

Answer 1

the "DateAdd()" function should do the trick.

See here for samples:

https://www.techonthenet.com/access/functions/date/dateadd.php

you would want to use:

endtime = DateAdd("n",75,starttime)

Answer 2

Hi RalphPoetiray,

Here in the link below you can find another examples of that.

Add to or subtract from date and time values

if you have any further questions you can ask.

Regards

Deepak

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.