Calculating Trip Time

[CSUjr]

I'm relatively new to Access 2007 and need some help in calculating,
and showing, how much time (hours:minutes) there is between a 'Start Time' & an 'End Time'.

I have imported the fields of my Table from Excel.
3 of these fields are;
Start Time (h:nn:ss AM/PM)


End Time (h:nn:ss AM/PM)
Total Time (= End Time - Start Time)

An example of these, in Excel, is;
[Start Time] (Q10) 11:00:00 AM
[End Time] (R10) 12:00:00 PM
[Total Time] (fx =R10-Q10) 1:00 (hour)

I have tried building a Query based on this,
in the Table and also in a Form (based on the Table),
but I can't seem to get either to work.

Can someone tell me how I can make the Total Time field auto-fill,
in hour:minute format, when the Start Time and then the End Time is entered into their fields?

With appreciation,
Charles

[NoellaG]

Hi,

try the function DateDiff.
For instance you can create the following calculated field in a query to get the amount of minutes between the 2 times:

fldMinutes: DateDiff("n",[Start Time],[End Time])

greetings
NG

[CSUjr]

Thank you for your reply.

I tried your suggestion in a few different ways without success.
I'm really not sure what I'm doing wrong, or not doing right.

First, I have a blank field in my Table that is labeled Trip Time.
and again, I'm trying to have the difference between
the Start Time & the End Time show (in hours & minutes)
in the field that is labeled Trip Time.

When I tried copying & pasting your suggestion;
fldMinutes: DateDiff("n",[Start Time],[End Time])
I got this error message;



Then I tried variations of this, including;
DateDiff("nn",[Start Time],[End Time])
but still with no success.
Can you tell me what I'm doing wrong, or not doing right?

With appreciation,
Charles