If and???

[slinky192001]

Hi

My spreadsheet is as shown below:

Column D
1 - Emergency
2 - High
3 - Normal

Column I
Date and Time

Column J
Date and Time

Column K
J2-I2 formatted as (h) MM:SS

I am trying to create a statement which says if column D is 1 - Emergency and column K is less than 48 hours then Yes in column L.

I have the following but its not working:

=IF((AND(D2="1 - Emergency", K2<"48:01")),"Y","N")

Any help would be fab.

Thanks

 

[VoG]

Try

=IF(AND(D2="1 - Emergency", K2<"48:01"+0),"Y","N")

 

[Jonmo1]

You have some unneeded parens, and you need to turn the text string "48:01" into a number to do a less than comparison...

J2-I2 will not be 48 hours, it will be 2 (as in 2 days)..so just do <2
Try

=IF(AND(D2="1 - Emergency", K2<2),"Y","N")

 

[JamesW]

Hi,

Try this:

=IF(AND(D1="1 - Emergency",(K1*24)<48),1,0)

 

[slinky192001]

Thank you for all your replies.

I have the format in hours and minutes as i will be going on to say if 2 - high is less than 54 hours 30 mins then Y otherwise no.

Can you explain why i would put +0 in the K2<'48:01'? It works but i dont understand what it does.

Thanks

 

[VoG]

"48:01" is a text value. Adding zero coerces it into a number representing a duration.