P
puiuluipui
Hi, i need an overtime formula with a difference of +/- 10 minutes, like in
the below example.
Ex:
Work hour : 08:00:00
08:00 - 16:25 overtime = 00:25 result(00:30)
08:00 - 16:19 overtime = 00:19 result(00:00)
08:00 - 16:50 overtime = 00:50 result(01:00)
08:00 - 16:49 overtime = 00:30 result(00:30)
I need the code to calculate from 30 to 30 minutes. But with a difference of
+/- 10 minutes.
If overtime is between 20 and 30, then the result of the code to be 30
minutes.
If overtime is between 50 and 60 (59:59), then the result of the code to be
1 hour
Can this be done?
Thanks!
the below example.
Ex:
Work hour : 08:00:00
08:00 - 16:25 overtime = 00:25 result(00:30)
08:00 - 16:19 overtime = 00:19 result(00:00)
08:00 - 16:50 overtime = 00:50 result(01:00)
08:00 - 16:49 overtime = 00:30 result(00:30)
I need the code to calculate from 30 to 30 minutes. But with a difference of
+/- 10 minutes.
If overtime is between 20 and 30, then the result of the code to be 30
minutes.
If overtime is between 50 and 60 (59:59), then the result of the code to be
1 hour
Can this be done?
Thanks!