time calculation

  • Thread starter Thread starter Pam
  • Start date Start date
P

Pam

I have a database with beginning times and ending times.
How do I do a query that will give me how much time it
took to do a project?
 
Dear Pam:

From a general question I can give a general answer.

I suggest you should first create a query that determines the duration
of each work period, then sum those.

Details of this depend on the structure of the data you have. But a
DateDiff (a function you will need to use) will give the duration of
each work period to whatever resolution you choose to specify.

I would write a query first that show things like who worked, when the
work period started, and how long it lasted. Then base another query
on this one to perform a sum.

Did this help?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Hi Pam,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

The following article should get you started in the right direction:

ACC: Functions for Calculating and Displaying Date/Time Values
http://support.microsoft.com/default.aspx?scid=kb;en-us;88657


I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support
 
DateDiff("nn",[TimeOrdered],[TimeOrderComplete])
Click to expand...

I'm surprised this works at all. "nn" is not a valid argument to
DateDiff; "n" is minutes. Also, DateDiff does NOT return a Date/Time
value such as 23:30; it returns an integer, 30 or -30. How are you
getting it to display as 23:30? What's the context of the call to
DateDiff?
 
Back
Top