From TimeStart + Minutes get TimeStop

[Céline Brien]

Hi there !
In a query I have the time the activity started [TimeStart] and the duration
[Minutes].
I would like to create the field TimeStop:[TimeStart]+[Minutes]
Activity started at 12:00, the duration is 90 minutes, the time it stop
would be 13:30
What is the formula ?
Many thanks,
Céline

 

[Duane Hookom]

Try:
TimeStop:[TimeStart]+[Minutes]/1440
or
TimeStopateAdd("n",[Minutes],[TimeStart])

 

[Céline Brien]

Hi Duane,
Thank you so much for your answer.
It is working perfectly !
Many thanks again,
Céline

Try:
TimeStop:[TimeStart]+[Minutes]/1440
or
TimeStopateAdd("n",[Minutes],[TimeStart])

--
Duane Hookom
Microsoft Access MVP

Hi there !
In a query I have the time the activity started [TimeStart] and the
duration
[Minutes].
I would like to create the field TimeStop:[TimeStart]+[Minutes]
Activity started at 12:00, the duration is 90 minutes, the time it stop
would be 13:30
What is the formula ?
Many thanks,
Céline