• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Mean time resolution

V

villival

Member
Hi
i could i find the mean time resolution rate for attached open and resolved date
thanks
 

Attachments

  • MTR.xlsx
    9 KB · Views: 8
Hi ,

Can you explain which cell(s) should have formulae , and how the result of the formulae should be derived using the input data that you have in your workbook ?

Narayan
 
NARAYANK991 said:
Hi ,

Can you explain which cell(s) should have formulae , and how the result of the formulae should be derived using the input data that you have in your workbook ?

Narayan
Click to expand...

hi narayan
you can insert formuale next c column, i got excel from itsm tool am looking for down time and mttr .. so that i can give the trend report .. thanks
 
Hi ,

Sorry , but nothing is clear.

In column C , you already have some values ; what are these values , and how have you arrived at them ?

Narayan
 
Hi ,

So what is it that you want to do with these values ?

If these values are in column C , then how can the formula also be in column C ?

I am sorry , but unless there is a clearer explanation , I am not able to help.

Narayan
 
villival said:
hi narayan
you can insert formuale next c column, i got excel from itsm tool am looking for down time and mttr .. so that i can give the trend report .. thanks
Click to expand...

Hi,

If I understood it correctly, downtime can be calculated by the difference of resolved and opened. But to calculate MTTR, I think you will also need date & time of respond to the call.

Regards,
 
You must log in or register to reply here.
Back
Top