How to do Time Calculations in Access

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculations 5
Time Calculations 5
Date & Time Calculations in Queries 1
Query set-up not using cross-tab 9
Access DateDiff function 0
Query: Billable Hours vs. Non-Billable Hours 3
How to do calculations in access 3
Calculate time difference 3

Top