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

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)

"Tim" wrote in message
...

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

of course, thankyou!

Tim


"Bob Phillips" wrote:

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)

"Tim" wrote in message
...

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

=(a1/(a2*24)

a1 = things
a2 = time


--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: http://www.excelforum.com/member.php...o&userid=32258
View this thread: http://www.excelforum.com/showthread...hreadid=522112

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

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

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