On 28-Jan-06, at 5:05 PM, Phil M wrote:
On Jan 28, 2006, at 3:28 PM, Terry Ford wrote:
Personally I would do a full Date-Time for every employee in and
out. What is really the most important is not the time punch but
the difference between the in and out. This is most easily
calculated by using the Date.TotalSeconds property:
But in the real world, people are not paid by that difference but
more by the relative nature of the punch in and punch out times to
the expected start and stop times of that shift. Any deviance from
that is usually flagged and adjusted later by the payroll department.
I have a personal beef with that because one of my employers
rounded the time to the nearest 15 minutes (to make it easy to
calculate).
<snip>
Dealing with employees who are late to shift is a different matter
but should not be attached to payroll.
And this thread is getting off-topic as far as the OP's original
question of how to store the punch clock date and time information in
a Database.
I do agree with you as far as the way this data is treated by many
corporations, but that is another OT topic entirely
Cheers,
Terry
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
