software

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)

quot;Timquot; gt; wrote in message
...
gt;
gt; I have got a couple of fiqures, the total time spent doing somthing,
gt;
gt; format (h):mm
gt;
gt; And the number of things done
gt;
gt; but when i try to calculate the number of things done per hour, it dosent
gt; work.
gt;
gt; the caluculation should work out to be
gt;
gt; 51 (things)
gt; 20:31:44 (hours) - (shown on excel as 20:31 due to my formating)
gt; should equal 2.49 per hour
gt; but the calculation comes to 59.62??????
gt;
gt; Please help

=(a1/(a2*24)

a1 = things
a2 = time--
MABeatty
------------------------------------------------------------------------
MABeatty's Profile: www.excelforum.com/member.php...oamp;userid=32258
View this thread: www.excelforum.com/showthread...hreadid=522112of course, thankyou!

Timquot;Bob Phillipsquot; wrote:

gt; Time is store as a fraction of 1 day, so you need to multiply by 24
gt;
gt; =things_done/(time_taken*24)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Timquot; gt; wrote in message
gt; ...
gt; gt;
gt; gt; I have got a couple of fiqures, the total time spent doing somthing,
gt; gt;
gt; gt; format (h):mm
gt; gt;
gt; gt; And the number of things done
gt; gt;
gt; gt; but when i try to calculate the number of things done per hour, it dosent
gt; gt; work.
gt; gt;
gt; gt; the caluculation should work out to be
gt; gt;
gt; gt; 51 (things)
gt; gt; 20:31:44 (hours) - (shown on excel as 20:31 due to my formating)
gt; gt; should equal 2.49 per hour
gt; gt; but the calculation comes to 59.62??????
gt; gt;
gt; gt; Please help
gt;
gt;
gt;

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

The correct result is 0,40252723HTH

--
AP

quot;Timquot; gt; a écrit dans le message de
...
gt;
gt; I have got a couple of fiqures, the total time spent doing somthing,
gt;
gt; format (h):mm
gt;
gt; And the number of things done
gt;
gt; but when i try to calculate the number of things done per hour, it dosent
gt; work.
gt;
gt; the caluculation should work out to be
gt;
gt; 51 (things)
gt; 20:31:44 (hours) - (shown on excel as 20:31 due to my formating)
gt; should equal 2.49 per hour
gt; but the calculation comes to 59.62??????
gt;
gt; 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)

quot;Ardus Petusquot; gt; wrote in message
...
gt; Assuming things is in A1, hours is in A2, result in A3
gt; =A2*24/A1 (format Standard)
gt;
gt; The correct result is 0,40252723
gt;
gt;
gt; HTH
gt;
gt; --
gt; AP
gt;
gt; quot;Timquot; gt; a écrit dans le message de
gt; ...
gt; gt;
gt; gt; I have got a couple of fiqures, the total time spent doing somthing,
gt; gt;
gt; gt; format (h):mm
gt; gt;
gt; gt; And the number of things done
gt; gt;
gt; gt; but when i try to calculate the number of things done per hour, it
dosent
gt; gt; work.
gt; gt;
gt; gt; the caluculation should work out to be
gt; gt;
gt; gt; 51 (things)
gt; gt; 20:31:44 (hours) - (shown on excel as 20:31 due to my formating)
gt; gt; should equal 2.49 per hour
gt; gt; but the calculation comes to 59.62??????
gt; gt;
gt; gt; Please help
gt;
gt;
You're damned right!

--
AP

quot;Bob Phillipsquot; gt; a écrit dans le message
de ...
gt; You have inverted the objective, he wants items per hour, not time per
item.
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Ardus Petusquot; gt; wrote in message
gt; ...
gt; gt; Assuming things is in A1, hours is in A2, result in A3
gt; gt; =A2*24/A1 (format Standard)
gt; gt;
gt; gt; The correct result is 0,40252723
gt; gt;
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; --
gt; gt; AP
gt; gt;
gt; gt; quot;Timquot; gt; a écrit dans le message de
gt; gt; ...
gt; gt; gt;
gt; gt; gt; I have got a couple of fiqures, the total time spent doing somthing,
gt; gt; gt;
gt; gt; gt; format (h):mm
gt; gt; gt;
gt; gt; gt; And the number of things done
gt; gt; gt;
gt; gt; gt; but when i try to calculate the number of things done per hour, it
gt; dosent
gt; gt; gt; work.
gt; gt; gt;
gt; gt; gt; the caluculation should work out to be
gt; gt; gt;
gt; gt; gt; 51 (things)
gt; gt; gt; 20:31:44 (hours) - (shown on excel as 20:31 due to my formating)
gt; gt; gt; should equal 2.49 per hour
gt; gt; gt; but the calculation comes to 59.62??????
gt; gt; gt;
gt; gt; gt; Please help
gt; gt;
gt; gt;
gt;
gt;