Formula needed for dividing hours by numbers

O

oxicottin

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
 
D

David Biddulph

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?]
 
O

oxicottin

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




David Biddulph said:
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 said:
the number is not always going to be 200,000
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complex Timesheet 10
Formula for calculating target hours against actual hours 12
If Formula 2
Need formula help 3
Convert a number to Hours, Minutes, etc. 3
dividing a number into hours and minutes 1
Excel formula 5
Convert Figure to Time HH:ss 3

Top