Hi Mangesh

Here is an example of the data and formula.

A
1 0:31:51
2 0:00:00
3 0:30:20
4 0:00:09

The formuala to caculate the rank is =RANK(A1,$A$2:$A$4,1). I've also tried
=RANK(A1,$A$2:$A$4,0).

It returns the value #DIV/0! and the error states "the
formula or function used is dividing by zero or empty cells".

The cells are in TIME format. Although I have tried number and general and
even text.

Thanks

Michael

"Mangesh Yadav" wrote:

can you show the exact formula you have used and the inputs to it.

Mangesh




"Michael" wrote in message
...
Hi there

I am working on a spreadsheet to measure agent performance. I want to
rank
agents on the time they spend in "wrap up" after each call. I've tried
using
the RANK formlua but it returns a value #DIV/0! and the error states "the
formula or function used is dividing by zero or empty cells".

However, the cells are empty. I've tried changing the cell format but its
not working.

Any Ideas?

THanks