Maybe

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Cyrus" <Cyrus@discussions.microsoft.com> wrote in message
news:32F8E5D1-0BE5-42EB-B3AA-21DE9E6FA37F@microsoft.com...
> 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