combine formulas

[dude2125]

OK an easy one here, while I am trying to figure out formulas for myself. I want to combine the two formulas into one. I tried an OR statement but no success, please help. The formulas are linked to a cell that is formated for time (1:30 PM) which is also causing me problems.

=if(a2<4,"DV")
=if(a2=4,"CL")

Thank you,

Duane

[ratcat]

G'day,

Try this, but it only works for 24 hour time.

Please Login or Register  to view this content.

Since I'm on a 10 min break at work, as soon as I can I'll figure out the 12 hour bit. You'll be the first to know.

Cheers

[dude2125]

Hey RatCat, the formula works great even in the 12 hour format. I have noticed if you use a 24 hour format that in the formula bar it still uses the 12 hour format.

Duane

[dude2125]

Another issue is that if the cell it is pointing to is blank it returns "DV". I can I make it blank?

[rylo]

Hi

For the blank aspect

=IF(ISBLANK(A2),"",IF(A2=TIME(16,0,0),"CL",IF(A2<TIME(16,0,0),"DV","")))


rylo

[dude2125]

Works perfect, Thank you for your help!!