HELP PLEASE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The values in Column G are minutes so I may need to also know how to
convert hours to total minutes to make the formulas work.
 
Try

=IF(I5<=30,H33,IF(AND(I5>30,I5<=45),H34,IF(AND(I5>45,I5<=60),H35,IF(AND(I5>6
0,I5<=90),H36,H37))))

for the second part. You might have to explain that hours to total minutes
thing if it is still a problem.

Doug

Keith wrote in message ...
 
Not meant as a criticism. If I5<=30 then it will not reach the second IF
test so the "I5>30" is superfluous because if must be greater than 30 to get
to that point. Your formula can therefore be shortened to:

=IF(I5<=30,H33,IF(I5<=45,H34,IF(I5<=60,H35,IF(I5<=90,H36,H37))))


Regards

Sandy
 
You must log in or register to reply here.

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

Excel formula 2
help again 1
Concerting total minutes to hours and minutes 7
Time Calculation 4
Help with time formatting 2
Excel formula 5
dividing a number into hours and minutes 1
converting formula for whole numbers to time 3

Back
Top