Start - Stop Time Fields

[Jarvis]

I'm building a time clock.

I have four fields: START --- STOP --- ELAPSED TIME --- TOTAL TIME

START & STOP are scripted buttons which insert the current time into the fields.

ELAPSED TIME is the calculation STOP-START

TOTAL TIME is a summary field that sums ELAPSED TIME in all records.

Everything does what it is supposed to do as long as START & STOP have both been activated. If only START is activated, the resultant ELAPSED TIME shows up as a

negative value and skews the TOTAL TIME.

Is there another way to get to this calculation STOP minus START that won't end up

temporarily in a negative value?

Thanks,

Jarvis

[RalphL]

Try using this for the calculation of Elapsed Time:

Case ( IsEmpty (Stop) ; 0 ;

Start - Stop)

[Jarvis]

Thanks Ralph.

You're golden!

Jarvis

[Vaughan]

You're going to hit trouble when the start-stop period stradles midnight. All these negative time periods will appear.

To resolve the issue you also need to record start and finish DATES and incorporate them into the elapsed time calculation.

Though since you are using FMP 7 you might be able to avoid the problem by using TIMESTAMP instead of simple TIME.

[Jarvis]

Thanks Vaughan,

Jarvis