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