[AccessD] Calculating Time Cards

Won't the GetElapsedTime() Sample function in Article Q210604 work for
you?



John V. Ruff - The Eternal Optimist :-)
Always Looking For Contract Opportunities

Home: 253.588.2139
Cell: 253.307.2947
9306 Farwest Dr SW
Lakewood, WA 98498

"Commit to the Lord whatever you do,
                and your plans will succeed." Proverbs 16:3



-----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 8: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