Time lapsed - with no end time and on the fly?

[wattmhite]

I have 2 fields, time in and time out that are filled in when a user clocks in or clocks out.

I'm trying to create a 3rd field that calculates the lapsed time. If there is no end time then the field should (get current time) so these hours are calculated on the fly.

Here is my field calculation so far:

Case( Time Out; Time Out - Time In;

IsEmpty (Time Out); Get( CurrentTime ) - Time In )

[comment]

Your calculation is a little awkward because it checks the same thing twice, but other than that it should work. Of course, any calculation that uses Get ( CurrentTime ) must be unstored. This may add unnecessary burden on reporting. Consider keeping the calculation stored, e.g. as =

If ( Time Out ; Time Out - Time In )

and displaying the alternative calculation as a placeholder.

Edited June 26, 2017 by comment