excel query in access

hights

New member
Local time
Today, 23:01
Joined
Apr 10, 2013
Messages
9
Hi, I have a query that displays the start and finish time for an activity,
I am trying to display the reults of the time between each activity....
For example
Name start End
aaa 14:07 14:09
aaa 14:11 14:12

The end time for the first activity was 14:09 and the next job was started at 14:11, so I want it to display 00:02: - (elapsed time)

Its very easy to do in excel as it would be =SUM(B2-C1) but haven't a clue how to do it in access.... is there any way? Thanks
 
Last edited:
Hi Plog, I have tried the datediff and it will calculate the difference between the start and finish time,(unless I am doing something wrong) - what I want is the time between when they finish a job and start a new job for example in red below....
Name Start Finish
aaa 14:07 14:09
aaa 14:11 14:12

Thanks,
 

Users who are viewing this thread

Back
Top Bottom