Hello, I have a excell sheet at work and my boss wants a new calculation to
show and I cant figure it out because im semi new at this. I need a formula
that will let me divide lets say 40 hours but its in 40:00 format by a number
lets say 200,000. How is this achieved? The reason the 40:00 in in that
format is because that is being used in another calculation. Then I think if
that number that is give is greater than 7250 per hour then it will give a
number 1 in that cell. Please help.....


This is the example he wrote to me:

Total Linear Footage Week ÷ Total Gross Hours Week = Weekly Lunch

Awarded

( 7250 ft/per hour)






Thanks,
Chad

=200/(A1*24)

where A1 holds 40:00


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)




"oxicottin" wrote in message
...
Hello, I have a excell sheet at work and my boss wants a new calculation
to
show and I cant figure it out because im semi new at this. I need a
formula
that will let me divide lets say 40 hours but its in 40:00 format by a
number
lets say 200,000. How is this achieved? The reason the 40:00 in in that
format is because that is being used in another calculation. Then I think
if
that number that is give is greater than 7250 per hour then it will give a
number 1 in that cell. Please help.....


This is the example he wrote to me:

Total Linear Footage Week ÷ Total Gross Hours Week = Weekly Lunch

Awarded

( 7250 ft/per hour)






Thanks,
Chad

the number is not always going to be 200,000

"Peo Sjoblom" wrote:

=200/(A1*24)

where A1 holds 40:00


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)




"oxicottin" wrote in message
...
Hello, I have a excell sheet at work and my boss wants a new calculation
to
show and I cant figure it out because im semi new at this. I need a
formula
that will let me divide lets say 40 hours but its in 40:00 format by a
number
lets say 200,000. How is this achieved? The reason the 40:00 in in that
format is because that is being used in another calculation. Then I think
if
that number that is give is greater than 7250 per hour then it will give a
number 1 in that cell. Please help.....


This is the example he wrote to me:

Total Linear Footage Week ÷ Total Gross Hours Week = Weekly Lunch

Awarded

( 7250 ft/per hour)






Thanks,
Chad

If your 200000 is in A1 and your 40:00 in A2, then your formula is
=A1/(A2*24) and format the answer as General or Number, not as Time.

[I assume that you do want to divide your numbers by hours, not divide hours
by numbers as your subject line says?]
--
David Biddulph

"oxicottin" wrote in message
...
the number is not always going to be 200,000

"Peo Sjoblom" wrote:

=200/(A1*24)

where A1 holds 40:00

"oxicottin" wrote in message
...
Hello, I have a excell sheet at work and my boss wants a new
calculation
to
show and I cant figure it out because im semi new at this. I need a
formula
that will let me divide lets say 40 hours but its in 40:00 format by a
number
lets say 200,000. How is this achieved? The reason the 40:00 in in that
format is because that is being used in another calculation. Then I
think
if
that number that is give is greater than 7250 per hour then it will
give a
number 1 in that cell. Please help.....


This is the example he wrote to me:

Total Linear Footage Week ÷ Total Gross Hours Week = Weekly
Lunch

Awarded

( 7250 ft/per hour)

Thanks everyone for the help!!! I got it to work....




"David Biddulph" wrote:

If your 200000 is in A1 and your 40:00 in A2, then your formula is
=A1/(A2*24) and format the answer as General or Number, not as Time.

[I assume that you do want to divide your numbers by hours, not divide hours
by numbers as your subject line says?]
--
David Biddulph

"oxicottin" wrote in message
...
the number is not always going to be 200,000

"Peo Sjoblom" wrote:

=200/(A1*24)

where A1 holds 40:00

"oxicottin" wrote in message
...
Hello, I have a excell sheet at work and my boss wants a new
calculation
to
show and I cant figure it out because im semi new at this. I need a
formula
that will let me divide lets say 40 hours but its in 40:00 format by a
number
lets say 200,000. How is this achieved? The reason the 40:00 in in that
format is because that is being used in another calculation. Then I
think
if
that number that is give is greater than 7250 per hour then it will
give a
number 1 in that cell. Please help.....


This is the example he wrote to me:

Total Linear Footage Week ÷ Total Gross Hours Week = Weekly
Lunch

Awarded

( 7250 ft/per hour)