question....please HELP....

[nadav.katz]

Hello,

I am facing the following problem....I am an access newbie:

I have to make a form which has the following controls - DayHours,
NightHours, TotalHours.

Day shifts are defined as shifts from 7am until 6pm
Night shifts are defined as shifts from 6pm until 7am

I have a table with EmployeeID, StartTime, EndTime.

As an example, if exmployee X worked from 1pm until 10pm - that should
count as 6 day work hours and 3 night work hours.

How could I implemet such a system that works out the day and night
work hours based on the shift times???


Many thanks in advance,

Nadav

 

[BruceM]

You have posted the same question in the main Access group, so I will try to
steer further discussion there. You can address one message to several
groups if you must (although it is rarely necessary), but posting the same
message separately to several groups tends to waste everybody's time, and is
considered a breadh of newsgroup etiquette. More here:
http://www.mvps.org/access/netiquette.htm

 

[scubadiver]

I think you would have to use the 24hour clock and use IIF statements to do
calculate the difference.