Suppress calc in table field calculation when not all elements of the equation are present

[chrisknight55]

EDIT: Figured this out. So simple. Rather than use a field calculation in the table, I just calc it in the same script that enters the ClockOut timestamp.

In a timeclock program, a timestamp is entered into a ClockIn field first, then when the employee leaves a timestamp is entered into a ClockOut field. A calculation field shows how many hours between the two.

But it gives an error number (-176221) when only the clockIn field is filled.

How can I suppress that (for aesthetics mostly) until the 2nd field is filled?

thanks

[Vaughan]

Case( not Isempty( timestampfield1 ) and not isempty( timestampfield2 ) ; <calculation> )

[chrisknight55]

Case( not Isempty( timestampfield1 ) and not isempty( timestampfield2 ) ; <calculation> )

Mostly, Thanks.

[Vaughan]

Mostly?

[chrisknight55]

Mostly?

Really sorry. Below your picture it says 'Mostly Harmless' and I thought that was your username ( it could happen...). I see now your name is Vaughn.

So I meant:

Vaughn, thanks...

Sorry. Cute works 50% of the time, at best.