ABCDEFGHIJKLMNOPQRSTUVWX
1
FRT
2
0:01:31←
Click on D2 to see the formula for the deparment-level FRT
3
4
Ticket createdFirst responseAssigned toFRT
5
2/2/2023 11:32:002/2/2023 11:33:45John0:01:45
6
2/2/2023 11:39:102/2/2023 11:39:51Sarah0:00:41
7
2/2/2023 11:42:152/2/2023 11:43:11Anshu0:00:56
8
2/2/2023 12:38:002/2/2023 12:39:40Anshu0:01:40
9
2/2/2023 12:39:222/2/2023 12:42:12John0:02:50
10
2/3/2023 10:12:022/3/2023 10:13:29Sarah0:01:27
11
2/3/2023 10:42:402/3/2023 10:43:49Anshu0:01:09
12
2/3/2023 11:02:002/3/2023 11:03:43John0:01:43
13
14
AgentFRTVS team average
15
John0:02:0637.9%
16
Sarah0:01:04-30.0%
17
Anshu0:01:15-17.9%
18
←
Click on B2, B3, B4 to see the formula for agent-level FRT
19
20
Make a copy of this spreadsheet and add your data.
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100