How to do Time Calculations in Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Someone - 11 Aug 2006 00:22 GMT

I am working on a database for tracking billable hours. In the database I
have a table set up that employees enter their daily time. I have two fields
TimeStarted - Medium Time Format - Input Mask 09:00\ >LL;0;_. This is the
same for both and TimeFinished. I am then creating a query that shows by
client TimeStarted and TimeFinished. I want to perform a calculation in the
query that does the following TimeFinished-TimeStarted and it returns the
exact number of minutes on the client. I cannot get this to work properly.
Any suggestions?

Reply to this Message

Allen Browne - 11 Aug 2006 05:18 GMT

Use DateDiff, with n for minutes (since m returns months):
DateDiff("n", [TimeStarted], [TimeFinished])

More info:
Calculating elapsed time
at:
http://allenbrowne.com/casu-13.html

Signature

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.

>I am working on a database for tracking billable hours. In the database I
> have a table set up that employees enter their daily time. I have two
[quoted text clipped - 6 lines]
> exact number of minutes on the client. I cannot get this to work properly.
> Any suggestions?

Reply to this Message