get average per hour?

[Guest]

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

 

[Bob Phillips]

Time is store as a fraction of 1 day, so you need to multiply by 24

=things_done/(time_taken*24)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[MABeatty]

=(a1/(a2*24)

a1 = things
a2 = time

 

[Guest]

of course, thankyou!

Tim

Time is store as a fraction of 1 day, so you need to multiply by 24

=things_done/(time_taken*24)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Ardus Petus]

Assuming things is in A1, hours is in A2, result in A3
=A2*24/A1 (format Standard)

The correct result is 0,40252723


HTH

 

[Bob Phillips]

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]

You're damned right!

--
AP

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)