How to calc MTTR(mean time to resolve)?

[#1]

Hi,

I have a around 1lakh of data. I need to calculate the mean time to resolve for the overall tickets that are present in the dump.

for example:

Number	Opened	Closed
1022	3/18/2015 16:04	3/19/2015 23:55
1023	3/19/2015 7:25	3/19/2015 12:33
1024	3/16/2015 15:31	3/18/2015 9:20
1025	3/23/2015 8:15	3/24/2015 9:40
1026	3/23/2015 8:20	3/24/2015 9:40
1027	3/23/2015 8:33	3/24/2015 9:37
1028	3/23/2015 8:39	3/24/2015 9:40
1029	3/23/2015 8:42	3/24/2015 9:36
1030	3/23/2015 8:23	3/24/2015 9:40
1031	3/23/2015 8:24	3/24/2015 9:40
1032	3/23/2015 8:41	3/24/2015 9:34
1033	3/23/2015 8:44	3/24/2015 9:37
1034	3/16/2015 15:34	3/17/2015 12:28

thanks in advance

[oknotsen]

You mean something like this?

sum(Closed - Opened)/count(Number)

[#3]

yes

[#4]

I want it in hours

[Chanty4u]

sum(Closed - Opened)/count(TOTAL Number)

[oknotsen]

Multiply by 24 .

[thetpaing]

it is working for me, thanks all