time function access2000

[Alfred]

Hi,
i'am working at a project in an ac2000 enviroment. I need a function to
calculate the difference between startt and end-time. I want the reuslt in
the followed format " d "days and " hh " hours" and "nn" minutes
I the difference is smaller than 24 hours, the format should be "" hh "
hours" and "nn" minutes
If the endtime is not known, i want the difference between the time of begin
and now(().
the format of the end and begin-time = dd-mm-yyyy hh:nn (european notation)

I've already tried with the function datediff, bu i can't figure it out. The
end time can sometimes been in another month ,
I thougt it was rather easy tocalculate the difference, but it is not. It's
quite the opposite. A little help, wil be appreciated.
I will use the function(fTimeElapsed) in mine query in the field
"Timedifence: fTimeElapsed(endtime, begintime)"
thanks alfred

many, many thanks alfred

[Allen Browne]

You will need to code your own function to handle the nulls and suppress the
unnecessary periods, but Doug Steele has a more complete DateDiff() function
you can use as a start here:
http://www.accessmvp.com/djsteele/Diff2Dates.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alfred" <fr**@kolkoe.ru> wrote in message
news:44***********************@news.skynet.be...

Hi,
i'am working at a project in an ac2000 enviroment. I need a function to
calculate the difference between startt and end-time. I want the reuslt in
the followed format " d "days and " hh " hours" and "nn" minutes
I the difference is smaller than 24 hours, the format should be "" hh "
hours" and "nn" minutes
If the endtime is not known, i want the difference between the time of
begin and now(().
the format of the end and begin-time = dd-mm-yyyy hh:nn (european
notation)

I've already tried with the function datediff, bu i can't figure it out.
The end time can sometimes been in another month ,
I thougt it was rather easy tocalculate the difference, but it is not.
It's quite the opposite. A little help, wil be appreciated.
I will use the function(fTimeElapsed) in mine query in the field
"Timedifence: fTimeElapsed(endtime, begintime)"
thanks alfred

[Bob Quintal]

"Alfred" <fr**@kolkoe.ru> wrote in
news:44***********************@news.skynet.be:

Hi,
i'am working at a project in an ac2000 enviroment. I need a
function to calculate the difference between startt and
end-time. I want the reuslt in the followed format " d "days
and " hh " hours" and "nn" minutes I the difference is smaller
than 24 hours, the format should be "" hh " hours" and "nn"
minutes If the endtime is not known, i want the difference
between the time of begin and now(().
the format of the end and begin-time = dd-mm-yyyy hh:nn
(european notation)

I've already tried with the function datediff, bu i can't
figure it out. The end time can sometimes been in another
month , I thougt it was rather easy tocalculate the
difference, but it is not. It's quite the opposite. A little
help, wil be appreciated. I will use the
function(fTimeElapsed) in mine query in the field
"Timedifence: fTimeElapsed(endtime, begintime)" thanks alfred

many, many thanks alfred

Do a google search for the Sec2Dur() function I posted here for
formatting, then simply do a
datediff("s", starttime, nz(endtime,now())

You'll need ot modify it to split out the days, and hide the
seconds as it now reports only hours:minutes:seconds. It does
however properly handle time across months and even a year or
two.
--
Bob Quintal

PA is y I've altered my email address.