By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,098 Members | 2,054 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,098 IT Pros & Developers. It's quick & easy.

Calculating amount of time spent on a project

P: n/a
What should I put in a query that would, if I have a start time and an
end time, tell me how much time was spent on a project.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
DateDiff("hh:mm",[StartTime],[EndTime])

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
<gz*****@linerlaw.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
What should I put in a query that would, if I have a start time and an
end time, tell me how much time was spent on a project.

Nov 13 '05 #2

P: n/a
PC Datasheet wrote:
DateDiff("hh:mm",[StartTime],[EndTime])
<gz*****@linerlaw.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
What should I put in a query that would, if I have a start time and
an end time, tell me how much time was spent on a project.


Huh? "hh:mm" is not a valid first argument for DateDiff.

DateDiff("n",[StartTime],[EndTime])

....will give you the minutes though.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #3

P: n/a
Thank you it worked!

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.