How we get Response/Resolution and Average turn around time ? Can anyone tell me exact formula for these?

How we get Response/Resolution and Average turn around time ? Can anyone tell me exact formula for these?

From 8/12 through 10/30 a total of 484 email inquiries, 675 email responses, averaging 1.39 responses per resolution.

 

Emails

Responses

Response/ Resolution

Average Turn Around Time

8/12-8/16/15

59

97

1.64

7:37:45

8/17-8/23/15

88

89

1.01

7:44:07

8/24-8/30/15

40

53

1.33

6:58:37

8/31-9/06/15

38

55

1.45

6:29:31

9/7-9/13/15

23

32

1.39

5:19:41

9/14-9/20/15

48

50

1.04

9:09:39

9/21-9/27/15

43

75

1.74

14:26:01

9/28-10/4/15

22

26

1.18

12:38:09

10/5-10/9/15

20

28

1.4

6:51:50

10/10-10/16/15

29

32

1.1

7:43:47

10/17-10/23/15

15

30

2

13:04:34

10/24-10/30/15

59

108

1.83

15:00:03

Total

484

675

1.39

11:21:15



Can anyone tell me exact formulas for desire column?