=TEXT(IF(M2-L2>0,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