Date difference between two columns and consecutive rows

[Data_Planner]

Hello,

I'm looking at analysing a database that is being produced by a machine with each row representing a new job. The machine outputs into two columns a start time and end time.

What I would like to calculate is the difference in time between when job 1 ends and job 2 starts. This will allow me to analyse what the turn around time of each job is. This would be easy to do in Excel (e.g. C3 - D2) however the raw data is in an Access database file.

autoidJob	txtJobName	dtTimeStart	dtTimeEnd
1	150701_1.cli	02/07/2015 16:22	02/07/2015 16:46
2	150701_1.cli	02/07/2015 17:12	03/07/2015 05:45
3	150702_2.cli	03/07/2015 05:52	03/07/2015 06:12
4	150703_1.cli	03/07/2015 10:41	03/07/2015 15:55
5	150703_2.cli	03/07/2015 16:04	04/07/2015 02:35
6	150706_2.cli	06/07/2015 13:44	06/07/2015 21:31
7	150706_1.cli	06/07/2015 21:41	07/07/2015 06:04
8	150707_1_slice.fabbproject.cli	07/07/2015 13:51	08/07/2015 02:37
9	150609_1.cli	08/07/2015 12:50	09/07/2015 02:22
10	150709_1_slice.fabbproject.cli	09/07/2015 11:49	09/07/2015 20:04
11	150710_1_slice.fabbproject.cli	10/07/2015 10:36	10/07/2015 18:36
12	150714_1.cli	14/07/2015 11:26	14/07/2015 15:45
13	150715_1.cli	15/07/2015 11:54	16/07/2015 03:54
14	150715_2.cli	16/07/2015 04:04	16/07/2015 10:02
15	150716_1.cli	16/07/2015 10:31	16/07/2015 10:35

Any ideas???

Thanks

[Greg_Deckler · Accepted solution]

See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395...

[Data_Planner]

Hi Greg,

The solution in your article works a treat, absolutely brilliant!

You've saved me so much time!

Cheers