FLOWERS Posted March 16, 2007 Posted March 16, 2007 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
mr_vodka Posted March 16, 2007 Posted March 16, 2007 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.
Recommended Posts
This topic is 6850 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now