Adding minutes to a time value

[load3d]

I have a field that holds a value called

Me.AppointmentTime

We'll say the user chose "9:00:00 AM" as the appointment time.


I want to take the me.appointmentTime value and add 5 minutes to it and set the value of another field to that value.


Me.time1 = me.appoitnmentTime + 5 minutes

me.time1 would then equal 9:05:00 AM

How do I make this happen?

 

[SkipVought]

TIME is store as DAYS

THEREFORE, Convert minutes to days

Me.time1 = TimeValue(me.appoitnmentTime) + 5/24/60

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[PHV]

Me.time1 = DateAdd("n", 5, Me.AppoitnmentTime)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[TonyJollans]

Personally I prefer what I think is clearer

[blue]Me.Time1 = Me.AppointmentTime + TimeValue("00:05")[/blue]

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website

 

[load3d]

Thanks everyone! This helped me out a lot.