You’re offline. This is a read only version of the page.
Currently working on the Timesheet tracker by @RandyHayes . I have questions regarding dates:
Well, the reality is, since you want not only that but also the multiple check ins and outs, that the architecture of that app is not really going to work for you.
What I would recommend is to restructure it to always work with the LAST record recorded for the user that does NOT have a check out time in it - or a new one if none exists.
The app was designed to do more of a record per day per user. So with the above concept, you would instead have a record per check in/check out per user and the day is not relevant.
That would give you the multiple check in/out ability and also cover the check out on another day.
Hi @RandyHayes
Thanks for the response. Could you please give me an example on how I could offset time? I'm also looking into possibility of multiple check ins/outs per day for employees who have flexible time. Would this be a challenge as well?
The sample Time Tracker app you are following was only intended to track daily times, not times that would cross the day boundary (i.e. 12 AM)
You could implement an offset time on all of your calculations, to account for the day boundary, but it is a challenge to do.
So, in other words, the architecture of that app was very specific to just a day. It would need to be adjusted completely for different periods of time.
As for the hour calculations, some years ago I replied to someone on this forum with an app that does summing of all the people and hours from the app. I'd hunt it down, but I feel it might not be worth it in this case since you really need to address non-day boundaries for check in/out.
@biancadevera how are you capturing Check In and Check Out? What's the action?
And for computation of hours use below formula.. replace with appropriate values for check in & check out..
Share
Report
All responses (
Answers (
76,308
DateDiff( DateTimeValue('Check In DateTime Value'), DateTimeValue('CheckOut Date Time Value'),Hours)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
