Bruce Bruen
bbruen at bigpond.com
Thu Jun 19 19:18:49 CDT 2003
Without having looked too closely at this thread.... I had a similar problem several years ago. The answer we employed was to build a temporary analysis table with the times adjusted backwards by the starting time of the first shift of the day. That is, analysisStart=realStart-(#4:00am#/24) type of thing. Thus the first shift starts at a virtual 12:00am, second at virtual 8:00am etc. The analysis then became easy. Hth Bruce -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mike and Doris Manning Sent: Friday, June 20, 2003 1:43 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Calculating Time Cards The easiest solution would be to build a shift table that contains the start and stop times for each shift. When the user clocks in, check the entry time against the shift table and set a Shift field in the time clock record to the appropriate value. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Julie Reardon-Taylor Sent: Thursday, June 19, 2003 11:09 AM To: accessd at databaseadvisors.com Subject: [AccessD] Calculating Time Cards Hi Everyone, Have a small problem that I'm hoping someone had encountered. Putting together a small application to calculate time cards. Running into some problems with the shift changes. This manufacturing firm uses a 7:00 am to 7:00 am day running three shifts. I've found several examples for calculating time cards in the knowledge base, but none seem to address the fact the "third shift" runs from 11:00 pm to 3:00 am. Of course, this means that one hour of the shift occurs on one date, and the other seven hours occur on the following date. I need to test the time input by the clerk and then based on the start and end times, determine which shift the hours fall between, then calculate time worked on each shift for each employee. Employees may clock in and out more than once during a day, and may also work overtime, as well as spread their hours between more than one shift. Most of this is already written, however, I am stumpled as to how to handle the third shift time differential? Julie Reardon-Taylor PRO-SOFT OF NY, INC. www.pro-soft.net _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com