hi,

anyone know how to calculte MTBF (mean time between failure) and MTTR(mean time between repair) ? i cannot find the correct formula. My data as below. Really need your helps. Thanks

Start Repair Date End Repair Date
01/10/2018 19:49 01/10/2018 21:23
01/10/2018 17:30 01/10/2018 18:17
01/10/2018 10:12 01/10/2018 12:42
01/10/2018 11:47 01/10/2018 14:27
01/10/2018 22:10 01/10/2018 22:52
01/10/2018 9:05 01/10/2018 10:08
01/10/2018 7:23 01/10/2018 11:24
02/10/2018 20:50 02/10/2018 20:51
02/10/2018 2:44 02/10/2018 6:40
02/10/2018 15:29 02/10/2018 15:30
02/10/2018 19:11 02/10/2018 20:43
02/10/2018 11:56 02/10/2018 12:35
02/10/2018 21:57 02/10/2018 23:13
02/10/2018 20:51 02/10/2018 22:14
02/10/2018 3:47 02/10/2018 6:37
02/10/2018 1:57 02/10/2018 3:27
02/10/2018 9:27 03/10/2018 9:59
02/10/2018 1:38 02/10/2018 3:29
02/10/2018 16:13 02/10/2018 18:29
02/10/2018 9:15 02/10/2018 13:22

Capture.JPG