calculating average handling time

[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

 

[Claus Busch]

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

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.

 

[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

 

[Claus Busch]

Hi,

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

you didn't try it!


Regards
Claus B.

 

[nitesh katoch]

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

 

[Claus Busch]

Hi,

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

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

have a look:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "Times"


Regards
Claus B.

 

[lhkittle]

Hi,



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






have a look:

https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326

for the workbook "Times"





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Hi Claus,
Shouldn't the column_Index column be like this?


0:00:00
0:45:01
0:50:01
0:55:01
1:00:01


Howard

 

[Claus Busch]

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

thank you for correction


Regards
Claus B.