Time Calculation

Hi Experts,

I have a field called starttime that is formated h:mm AM/PM.  I have added a new field called putime and traveltime.  I want to be able to calculate the pickup time by deducting the minutes of traveltime and 60 mins from starttime.

I have tried the following code but get an error:

    Me.putime = timeAdd("h:mm AM/PM", -60 - trvtime.Text, starttime)

Who is Participating?
raja_ind82Connect With a Mentor Commented:
starttime = Format(Now(), "h:mm AM/PM")
finaltime = DateAdd("n", 20, starttime) ' add twenty minutes...
MsgBox starttime
MsgBox finaltime

Have a look at this for more details on DATEADD:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.