Formals with IF and Then

[Guest]

I need help with a formula. I'm creating a spreadsheet where data entry
would indicate the time a patient arrives and than leaves. I need a formula
that calculates this, but displays nothing if no time is entered (for example
down the worksheet).

=IF((M2-L2)=0,""),IF((M2-L2)>0,"h:mm")

This is what I have...I keep getting value error.

i want the time to display if the time is greater than zero, but if less
than zero, display nothing.

Thanks,

Cyrus

 

[Bob Phillips]

Maybe

=IF(OR(M2="",L2=""),"",IF(M2-L2>0,M2-L2,""))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

=TEXT(IF(M2-L2>0,M2-L2,""),"h:mm")

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

=TEXT(MAX(M2-L2,0),"h:mm;;")

 

[Tim C]

Cyrus,

Try:

=IF(M2>L2,M2-L2,"")

With that formula, you will get a value if you have a departure time but no
arrival time. If that is a potential problem, use:

=IF((M2-L2)*L2>0,M2-L2,"")


In both cases, format the cell as time. If elapsed time may exceed 12
hours, use the custom number format [h]:mm


Tim C

 

[Guest]

It worked!!! Thanks so much!!!

Cyrus

=TEXT(IF(M2-L2>0,M2-L2,""),"h:mm")

Vaya con Dios,
Chuck, CABGx3