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
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: