Dividing a number into time to get a # per hour?

[CTOROCK]

how would I get the average number per hour
if the time is 3:00 , meaning 3 hours and I want to divide that by 25, how would I get the number per hour?

thanks! "The greatest risk, is not taking one."

 

[Zathras]

If you divide 3 hours by 25 you get hours per number, not numbers per hour... So I guess the answer to your question would be to take the reciprocal of your quotient.

 

[SkipVought]

Where are you getting 3:00 from?

If it is actually TIME, then 3:00 is in reality 3/24 or .125. So dividing 3:00 into 25 parts is 0:07:12 in [h]:mm:ss format

OR 3/25 = .12 hrs which is 7.2 minutes which is 7:12 -- SAME ANSWER VOLA!
Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Zathras]

Ok, all kidding aside, 25 divided by 3 is 8 1/3, so if you have:

A1: 3:00
B1: 25
C1: =B1/(A1*24)

<--need to reformat as General or Number

Note that by entering

3:00

into A1, Excel automatically converts that to 3 hours. The internal representation for that is .125 as can be seen by reformatting the cell to General. The interpretation of that is 1/8 of a day.