Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Overtime
0 views
Skip to first unread message
puiuluipui
Dec 11, 2009, 10:23:01 AM12/11/09
to
Hi, i need an overtime formula with a difference of +/- 10 minutes, like in
the below example.
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!
puiuluipui
Dec 11, 2009, 10:34:01 AM12/11/09
to
Sorry. I selected frontpage/general question by mistake.
Sorry again.
Sorry again.
"puiuluipui" a scris:
0 new messages