From TimeStart + Minutes get TimeStop

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Céline Brien - 30 Sep 2009 14:47 GMT

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

Reply to this Message

Duane Hookom - 30 Sep 2009 15:23 GMT

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

Signature

Duane Hookom
Microsoft Access MVP

> Hi there !
> In a query I have the time the activity started [TimeStart] and the duration
[quoted text clipped - 5 lines]
> Many thanks,
> Céline

Reply to this Message

Céline Brien - 30 Sep 2009 16:35 GMT

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

> Try:
> TimeStop:[TimeStart]+[Minutes]/1440
[quoted text clipped - 11 lines]
>> Many thanks,
>> Céline

Reply to this Message