get average per hour?
 

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

get average per hour?
 

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

get average per hour?
 

=(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

get average per hour?
 

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

get average per hour?
 

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

get average per hour?
 

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

get average per hour?
 

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