[SOLVED] Date / Time (Extracting time to another field after a specific time.)

Need help
1

Hey,

I made a clock, so with one button you can check in/out (a little more complex)
time-in: When you clock in
time-out: When you clock out
sum: The summary of time-out - time-in (then divide by 60, so you can see it in hours/minutes)

But now i’m struggling with, extracting overtime.
e.g
If someone works later then 05:00 pm, I want that time in the field “overtime”

I need suggestions, or maybe even a kind soul to help me out.

2

drop me the editor link I will see what I can do mate.

3

Hey, thanks.

got a little workaround (not a good one)
Overtime = Time out - Date&Time Value (07:00 pm) then press a bottom and voila the time is in “Overtime” field.
But i wanna do a little simpler, if possible.

4

Here is what we ended up with for anyone else that needs it. cheers

5

Thanks for the help

6

Hmm

So, this worked out great, got the hours.
But the problem is, i really need the minutes
since the “Extract” option, only take full hours,
so if the time is 17:32, it wont count the minutes.

Any suggestions?

7

ok, so we ended up hiding a decimal input to help out with the math - now it shows in minutes and can be changed to minute blocks, half hour and so on by adding a :roundedby operator to the end of overtime input.

good1.PNG391×547 15.5 KB
good2.PNG373×551 15.3 KB

8

Once again, thanks.
I bow to the master :slight_smile:

9

anytime mate. cheers