Formals with IF and Then
 

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

Formals with IF and Then
 

Maybe

=IF(OR(M2="",L2=""),"",IF(M2-L20,M2-L2,""))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cyrus" wrote in message
...
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

Formals with IF and Then
 

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

Vaya con Dios,
Chuck, CABGx3



"Cyrus" wrote:

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

Formals with IF and Then
 

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


"Cyrus" wrote:

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

Formals with IF and Then
 

Cyrus,

Try:

=IF(M2L2,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)*L20,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


"Cyrus" wrote in message
...
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

Formals with IF and Then
 

It worked!!! Thanks so much!!!

Cyrus

"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"Cyrus" wrote:

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