Overtime
in [FrontPage]
|
Prev: uploading to a server who does not support front page extensions.
Next: Hyperlink addition - finding a date when something is linked?
From: puiuluipui on 11 Dec 2009 10:23 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!
From: puiuluipui on 11 Dec 2009 10:34
Sorry. I selected frontpage/general question by mistake. Sorry again. "puiuluipui" a scris: > 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! > |