Date difference between two columns and consecutive rows

Question

Hello,&nbsp;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.&nbsp;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.&nbsp;autoidJobtxtJobNamedtTimeStartdtTimeEnd1150701_1.cli02/07/2015 16:2202/07/2015 16:462150701_1.cli02/07/2015 17:1203/07/2015 05:453150702_2.cli03/07/2015 05:5203/07/2015 06:124150703_1.cli03/07/2015 10:4103/07/2015 15:555150703_2.cli03/07/2015 16:0404/07/2015 02:356150706_2.cli06/07/2015 13:4406/07/2015 21:317150706_1.cli06/07/2015 21:4107/07/2015 06:048150707_1_slice.fabbproject.cli07/07/2015 13:5108/07/2015 02:379150609_1.cli08/07/2015 12:5009/07/2015 02:2210150709_1_slice.fabbproject.cli09/07/2015 11:4909/07/2015 20:0411150710_1_slice.fabbproject.cli10/07/2015 10:3610/07/2015 18:3612150714_1.cli14/07/2015 11:2614/07/2015 15:4513150715_1.cli15/07/2015 11:5416/07/2015 03:5414150715_2.cli16/07/2015 04:0416/07/2015 10:0215150716_1.cli16/07/2015 10:3116/07/2015 10:35&nbsp;Any ideas???&nbsp;Thanks

greg_deckler · Accepted Answer

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/339586

Forum Discussion

Date difference between two columns and consecutive rows

2 Replies

Related content

periods of consecutive instances

DAX Count consecutive

Different schema into different destination

Time Difference between consecutive rows

Calculating difference between consecutive rows

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