Calculate in specific date

Hi , I’m building a platform for school

and I created a workflow so the user - staff - check in/ out and then calculate the number of the hours between the time in and out

anyway I want school to be able to see total of hours in specific period of time , lets say from
2/01/2023 to 2/16/2023

I tried this and another kind of expression but it didn’t work

date

In my example I have two date/time picker elements (FROM and TO):

Screenshot 2023-02-16 at 20.16.29

Screenshot 2023-02-16 at 20.20.32

well how can I calculate the total hours between time in and time out in the two date/time picker elements (FROM and TO) ?

In date/time picker change input type Date → Date & Time:
Screenshot 2023-02-16 at 20.25.44

Here it is:
Screenshot 2023-02-16 at 20.25.34

sorry but I really don’t get it
let’s say some employee every day from 2/01/2023 to 2/16/2023 check in at 8:00 AM and Check out at 4:00 PM , so he worked 128 hours

how can I show the total of hours " 128 " ?

I tried what you told me and it didn’t work

128 hours is not a difference between 2/01/2023 and 2/16/2023 (15 days), 128 hours are just 5 days an 8 hours (but I guess you meant 2/06/2023 as the end date :slight_smile:).

So your exact example tested:
Screenshot 2023-02-16 at 20.50.03

Could you share your date/time pickers setup and the expression?

it’s didn’t work
I don’t know the problem

This topic was automatically closed after 70 days. New replies are no longer allowed.