From TimeStart + Minutes get TimeStop

  • Thread starter Thread starter Céline Brien
  • Start date Start date
C

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
 
Try:
TimeStop:[TimeStart]+[Minutes]/1440
or
TimeStop:DateAdd("n",[Minutes],[TimeStart])
 
Hi Duane,
Thank you so much for your answer.
It is working perfectly !
Many thanks again,
Céline

Duane Hookom said:
Try:
TimeStop:[TimeStart]+[Minutes]/1440
or
TimeStop:DateAdd("n",[Minutes],[TimeStart])

--
Duane Hookom
Microsoft Access MVP


Céline Brien said:
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
Click to expand...
Click to expand...
 
Back
Top