From TimeStart + Minutes get TimeStop

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
 
D

Duane Hookom

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

Céline Brien

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

new query, new problem 2
What is the date when the total of minutes became >=600 7
Check for Duplicate Shifts 3
Re-attack 4
asp webservice variables and persistence 6
Convert to VBA code? 4
Do not overwrite a field 7
Converting minutes to hours:minutes 4

Top