Calculate a Time Value

[casair]

Hello,

I have a form with a text box in which a user enters a departure time.
In another text box I would like to caluclate the departure time less 30 mins.

Is this possible?

Thanks

 

[Beetle]

Add an unbound text box to your form and set it's control source to;

=DateAdd("n", -30, [DepartureTime])

substitute your actual field name for [DepartureTime]

 

[casair]

Beetle

Thankyou soooo much, this has frustrated me for months.
It work perfecly
--
casiar

Add an unbound text box to your form and set it's control source to;

=DateAdd("n", -30, [DepartureTime])

substitute your actual field name for [DepartureTime]
--
_________

Sean Bailey

Hello,

I have a form with a text box in which a user enters a departure time.
In another text box I would like to caluclate the departure time less 30 mins.

Is this possible?

Thanks