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) ;)

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

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.

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

HTH

Lee

Hi Lee

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

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

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

Lee

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, 200520 yr by Guest
english version

Hi

here an English version.

NocturnalJobE.zip