=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