P
polk383
Hello All!
I never tried to do anything like this before so here goes! I am
trying to create a nested if then else statement. What I have is 7
fields one of which I created the other 6 where exported data. In the
6th field I have times in there that is subtracting a from fields B and
C. In field H There are times in the format [h]:mm:ss. I need to have
a statement showing that if the time is below 1:00:00 then in the cell
will be "less than 1 hour" if it is between 2 - 4 hours it will say
"between 2 - 4 hours" and if it is over 4 hours then it will show "Over
4 hours" Here is what I have created so far and I am unable to get this
thing to function correctly.
Code:
--------------------
=IF(H2<1:00:00,"Less than 1 hour",IF(H2>2:00:00,"Over 2 hours",IF(H2>4:00:00,"Over four hours")))
--------------------
I am at a loss to get this thing to see between 2 - 4 hours and just to
get it to function correctly!
Thanks everyone!!
I never tried to do anything like this before so here goes! I am
trying to create a nested if then else statement. What I have is 7
fields one of which I created the other 6 where exported data. In the
6th field I have times in there that is subtracting a from fields B and
C. In field H There are times in the format [h]:mm:ss. I need to have
a statement showing that if the time is below 1:00:00 then in the cell
will be "less than 1 hour" if it is between 2 - 4 hours it will say
"between 2 - 4 hours" and if it is over 4 hours then it will show "Over
4 hours" Here is what I have created so far and I am unable to get this
thing to function correctly.
Code:
--------------------
=IF(H2<1:00:00,"Less than 1 hour",IF(H2>2:00:00,"Over 2 hours",IF(H2>4:00:00,"Over four hours")))
--------------------
I am at a loss to get this thing to see between 2 - 4 hours and just to
get it to function correctly!
Thanks everyone!!