Prev: hubs
Next: select records where first letter of name begins with an a through
From: kft10 via AccessMonster.com on 31 Mar 2010 11:36
Hi,

I have field 'start_time' and 'duration_time' in minute. Do you know how to
get a 'End-Time' by adding 'start_time' + 'duration_time'? I tried to do that,
but the result is wrong. Any other function to get that?

Thank you in advance.

Rgds,
KFT

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1

From: Marshall Barton on 31 Mar 2010 12:04
kft10 via AccessMonster.com wrote:
>I have field 'start_time' and 'duration_time' in minute. Do you know how to
>get a 'End-Time' by adding 'start_time' + 'duration_time'? I tried to do that,
>but the result is wrong. Any other function to get that?

DateAdd("n". duration, starttime)

--
Marsh
MVP [MS Access]
From: golfinray on 31 Mar 2010 12:41
Try this:
Dateadd("m",[start time],[end time])
--
Milton Purdy
ACCESS
State of Arkansas


"kft10 via AccessMonster.com" wrote:

> Hi,
>
> I have field 'start_time' and 'duration_time' in minute. Do you know how to
> get a 'End-Time' by adding 'start_time' + 'duration_time'? I tried to do that,
> but the result is wrong. Any other function to get that?
>
> Thank you in advance.
>
> Rgds,
> KFT
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1
>
> .
>
From: John W. Vinson on 31 Mar 2010 13:15
On Wed, 31 Mar 2010 09:41:01 -0700, golfinray
<golfinray(a)discussions.microsoft.com> wrote:

>Try this:
>Dateadd("m",[start time],[end time])

That should be "n" for miNutes - "m" will add Months.
--

John W. Vinson [MVP]
From: kft10 via AccessMonster.com on 31 Mar 2010 13:29
It works, thank you so much. Can we use Dateadd function in Excel?

John W. Vinson wrote:
>>Try this:
>>Dateadd("m",[start time],[end time])
>
>That should be "n" for miNutes - "m" will add Months.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201003/1

 |  Next  |  Last
Pages: 1 2
Prev: hubs
Next: select records where first letter of name begins with an a through