Hello everyone, If anyone can help me.
Assuming I clock-in: 12PM and clock-out at 7:00PM (Total of 7HRS) How can I get the 7Hours? Please kindly show how it can be done? If it’s not too much to ask.
Thanks much!!!
Mark
Hi Mark @App_Up2,
Let’s assume you have 2 properties in some collection in the database: Clockin Time (type Datetime) and Clockout Time (type Datetime).
When you clock in, you put the current time to Clockin Time.
When you clock out, you put the current time to Clockout.
To calculate the difference in hours, you can add 3rd property, let’s call it Hrs, type Number. After you store clockout, you update Hours using an expression: (Clockout Time - Clockin Time) * 24.
Best,
Victor.
Hello Victor,
Is it something like this?
(see attachment)
For some reason I can’t seem to attach the screenshot. 
Would you by chance have an actual example, just so I can compare it with mine. If it’s not too much to as of a favor. It will help me so much!
Thanks in advance,
Mark
Hi @App_Up2,
Victor already covered this topic which can be explored in here 
(it’s the same explanation as above with some more information) : Time Calculation employee time clock - #2 by Victor
Also there’s another good explanation written by @NoCodeJedi. : Calculating time between two times in hours and minutes
Let us know how it goes!
Thank you and have a great day!
1 Like
My sincerest apology for getting further help, I am currently on Professional Plan in Adalo an just hoping someone can give me some assistance. I have been subscribed for almost two years now and hoping I can extend more. And again my apology for always asking assistance.
Hi @App_Up2,
No worries and sounds awesome!
With what you need help? Any more details?
Let us know!
Thank you and have a great day!
Thanks as well, It’s been my two years now on Professional plan. I just need to figure out how I can get the total hours, and with Pre-total.
(i.e.)
1.) If clocked in in at 8AM and Clockout 5PM = 8HRS
2.) If clocked in at 7:45AM and Clockout 5:15PM = 8HRS
Coz some of our employees forgets to clock-in since the system is new. If we can preset the time by 15mins earlier than 8AM and 15mins after 5PM, still gives 8hrs in total. (Fixed hours).
2nd scenario.
If clocked in 8:30AM and clocked out 5:00PM = to 7hrs and 30mins only. If triggered outside the preset time, it counts real-time hours.
I found something simillar, from appsheet. They also have calendar, wherein you can sort all the timesheet from a certain date. I want to do that with Adalo but I just can’t seem to make it work. 
@App_Up2 just in case: Adalo Forum is not an official support channel. Here Makers help each other and share their experiences with Adalo. Community Leaders like myself are not Adalo employees and we are not paid by Adalo.
So there are no any filters or priorities based on subscription plan.
As for your question - there has been some explanations in this thread. Did you try to implement anything based on that?
Best,
Victor.
1 Like
I agree with what Victor mentioned above!
Have you checked the Victor’s explanation and the posts I’ve linked? Those explanations should give you the solution to your initial/main problem in this thread which then you need to simply adjust the solution with some conditions.
Thank you and have a great day!