How to do Time Calculations in Access

[Someone]

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?

 

[Allen Browne]

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