Hello,
I help to generate a formula that will select an answer from a list (1-5) from the following range:
5= 0 to 4 hours
4= 4.01 to 12 hours
3= 12.01 to 24 hours
2= 24.01 to 28 hours
1= 28.01+ hours
I already have the calculation formula to generate the total number of hours. Now I need a formula to select a score (1-5) based on the above criteria.
The cell that has the answer for the calculation of time is AG6.
Thanks,
Jen
I help to generate a formula that will select an answer from a list (1-5) from the following range:
5= 0 to 4 hours
4= 4.01 to 12 hours
3= 12.01 to 24 hours
2= 24.01 to 28 hours
1= 28.01+ hours
I already have the calculation formula to generate the total number of hours. Now I need a formula to select a score (1-5) based on the above criteria.
The cell that has the answer for the calculation of time is AG6.
Thanks,
Jen