calculating average handling time

  • Thread starter Thread starter nitesh katoch
  • Start date Start date
N

nitesh katoch

Hi i have a excel sheet of people with their average handling time like

ray 00:38:42
james 01:08:57
tommy 00:51:29
jin 00:33:38
tim 01:28:57


now i want to grade them like
people with <= 00:45:00 grade 5
people with <=00:50:00 grade 4
people with <=00:55:00 grade 3
people with <=1:00:00 grade 2
people with >=1:01:00 grade 1

how do i use the formula in this
 
Hi,

Am Sun, 15 Dec 2013 10:45:16 -0800 (PST) schrieb nitesh katoch:
ray 00:38:42
james 01:08:57
tommy 00:51:29
jin 00:33:38
tim 01:28:57

now i want to grade them like
people with <= 00:45:00 grade 5
people with <=00:50:00 grade 4
people with <=00:55:00 grade 3
people with <=1:00:00 grade 2
people with >=1:01:00 grade 1
Click to expand...

make a helper table:

+----------+-----+
| G | H |
+----------+-----+
| 00:00:00 | 5 |
+----------+-----+
| 00:45:00 | 4 |
+----------+-----+
| 00:50:00 | 3 |
+----------+-----+
| 00:55:00 | 2 |
+----------+-----+
| 01:00:00 | 1 |
+----------+-----+

Then use in C1:
=VLOOKUP(B1,$G$1:$H$5,2,1)


Regards
Claus B.
 
Hi i have a excel sheet of people with their average handling time like



ray 00:38:42

james 01:08:57

tommy 00:51:29

jin 00:33:38

tim 01:28:57





now i want to grade them like

people with <= 00:45:00 grade 5

people with <=00:50:00 grade 4

people with <=00:55:00 grade 3

people with <=1:00:00 grade 2

people with >=1:01:00 grade 1



how do i use the formula in this
Click to expand...
 
Hi,

Am Sun, 15 Dec 2013 11:16:40 -0800 (PST) schrieb nitesh katoch:

you didn't try it!


Regards
Claus B.
 
i did

00:15:22
00:38:42
01:08:57
00:51:29
00:33:38
01:28:57
01:11:29
01:15:29
01:05:34
00:48:30
01:02:15
01:21:58
01:07:20
00:51:52
00:56:41
01:07:41
01:08:41
01:17:50
00:57:06
01:00:28
00:46:50
01:11:00
00:53:56
00:54:19
01:14:45
00:59:12
01:03:49
00:53:48
01:23:16
00:47:29
00:59:08
01:15:23
01:09:41
01:05:43
01:09:55


these are the AHT for people now i am not able to grade them in excel
 
Hi Howard,

Am Sun, 15 Dec 2013 17:10:01 -0800 (PST) schrieb (e-mail address removed):
0:00:00
0:45:01
0:50:01
0:55:01
1:00:01
Click to expand...

thank you for correction


Regards
Claus B.
 
Back
Top