Time Calculation

[Tracy]

I hope someone can help, I'm new to access and have a
question on determining the difference between 2 times. I
want to create a form or table in which I input a begin
and end time and then have Access display the difference
(in hours or someother usable format) that has occurred
between the 2 times.

Can anyone give me an example? I'm using Access 2000.

Thanks,
Tracy

 

[Tony]

Hey Tracy,

I would create a table that includes the following fields:

Field 1: StartTime
Field 2: EndTime
Field 3: any extra data
Field 4: any extra data

within your query use the following expression:

TimeDiff:[StartTime] - [EndTime] example: 10:00 am - 02:00
pm = 4hrs

Does this make sense?

Tony