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