nocturnal job

[Raybaudi]

Hi all friends

How would you calculate the worked nocturnal hours, knowing that the nocturnal timetable begins to the 22 and ends to the 6 ?

A worker can begin the turn at 20:30 and end at 2:30, or can begin at 2:00 and end at 8:30.

(or even other combinations) ;)

[VICH]

do you mean how do you caclculate over midnight or 24:00?

[Raybaudi]

the hour amount is various for diurnal and nocturnal job. As an example: $10 to the diurnal hour, $15 to the nocturnal hour. I begin work to the 20:00 of the 25/09/2005 and end to the 05:00 of the 26/09/2005. I will have worked 9 hours, 7 of which nocturnal.

[Lee Smith]

There are a couple of ways. Include the start date and end date, or use 30 as the end time.

HTH

Lee

[Raybaudi]

Hi Lee

I was thinking to go with two timestamp field, startTime and endTime...

[Lee Smith]

wow, you are fast on the pick up. I was going to edit my previous post, and add that, and also mention that one of my client that has this situation cuts off the day at midnight and starts with 00 and then 0600 works.

HTH

Lee

[Lee Smith]

p.s. I tried to post this at a 11:20 or so, and the site when kaput

Lee

[Raybaudi]

Hi all friends

it wasn't easy, but it seems to work

p.s. English version in the next post.

NocturnalJob.zip

Edited October 3, 2005 by Guest
english version

[Raybaudi]

Hi

here an English version.

NocturnalJobE.zip