You're damned right!

--
AP

"Bob Phillips" a écrit dans le message
de ...
You have inverted the objective, he wants items per hour, not time per
item.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ardus Petus" wrote in message
...
Assuming things is in A1, hours is in A2, result in A3
=A2*24/A1 (format Standard)

The correct result is 0,40252723


HTH

--
AP

"Tim" a écrit dans le message de
...

I have got a couple of fiqures, the total time spent doing somthing,

format (h):mm

And the number of things done

but when i try to calculate the number of things done per hour, it
dosent
work.

the caluculation should work out to be

51 (things)
20:31:44 (hours) - (shown on excel as 20:31 due to my formating)
should equal 2.49 per hour
but the calculation comes to 59.62??????

Please help