March 16, 200718 yr I have a timeclock solution where I need to show the elapsed time of a clock-in...... Example...clocked in at 8am, it is now 113pm and not clocked out - how long have they been clocked in? Just need the calculation
March 16, 200718 yr As a basic, Case ( not IsEmpty (ClockIn); Case ( IsEmpty (ClockOut); Get ( CurrentTime ) - ClockIn; ClockOut - ClockIn ) But if there is a chance that the time could be longer than 24 hours then you will have to accomodate for that. In that case, you may want to look into using timestamps as it returns the date or add a date field instead.
Create an account or sign in to comment