Correctly Write Formula For Time < 59 Minutes

[docwoody]

I have procedure start times in A1, end times in B1, and in C1 = the time calculated. I wrote a formula in D1 to enter "1" if the time is < 59 minutes. I used =IF(C1<TIME(0,59,0),1,""), but if C1 is blank it still returns as true. How can I still calculate in D1 that C1 is <59 minutes to return "1", but if the cell is blank to leave D1 blank? Help please.

Doc Woody

 

[shift-del]

Hi Doc Woody

How can C1 be blank if it contains a formula?

 

[dreid1011]

Maybe:

=IF(AND(C1<>"",C1<TIME(0,59,0)),1,"")

 

[docwoody]

Hi Doc Woody

How can C1 be blank if it contains a formula?

C1 is the time calculated between A1 and B1. If nothing is entered into A1 and B1, C1 will be blank. I want D1 to return blank if C1 is blank, but if a time is entered, I only want D1 to show "1" if the time is <59 minutes.

 

[docwoody]

Maybe:

=IF(AND(C1<>"",C1<TIME(0,59,0)),1,"")

Thanks dreid1011, unfortunately it did the same as the other fu=ormulas I have tried. It still returns "1" when C1 is blank. I have to figureout how to tell excel that the value shold be between 0-59 I guess. Thanks again.

 

[shift-del]

If A1 and B1 are empty then the whole calucation is needless.

 

[Fluff]

How about

=IF(or(C1="",C1>=TIME(0,59,0)),"",1)