Help determining when users are late

[Porky]

Scenario: login/logoff scripts that kick username, times, and dates out
to a CSV file. I have a linked table in access pointing to that CSV
file. Users typically log in and log out twice a day (they are required
by company policy to log out when they go to lunch).

Problem: I am trying to figure out a way to check when they logged in
first thing in the morning. Certain performance bonuses are based on
whether or not they logged into their systems before 8am (once again,
company policy). This needs to count the number of times they are
"late" (logged in after 8am) per week, and add it up for the month
(queries are typically on the calendar month). It would be great if it
could simultaneously go back and report on the late times for the
previous calendar quarter as well.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Gung Ho]

avoid a lot of trouble and legal expenses - buy time cards and a punch clock
if you want to track labour times

write a program like a screen saver that kicks off the operator on a set
time interval with inactivity, launch on each workstation at logon script

"Porky" <sc*****@noemail.net> wrote in message
news:#L**************@tk2msftngp13.phx.gbl...

Scenario: login/logoff scripts that kick username, times, and dates out
to a CSV file. I have a linked table in access pointing to that CSV
file. Users typically log in and log out twice a day (they are required
by company policy to log out when they go to lunch).

Problem: I am trying to figure out a way to check when they logged in
first thing in the morning. Certain performance bonuses are based on
whether or not they logged into their systems before 8am (once again,
company policy). This needs to count the number of times they are
"late" (logged in after 8am) per week, and add it up for the month
(queries are typically on the calendar month). It would be great if it
could simultaneously go back and report on the late times for the
previous calendar quarter as well.

Thanks.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Don Verhagen]

In news:7r********************@golden.net,
Gung Ho <mi***********@netlane.com> typed:
: avoid a lot of trouble and legal expenses - buy time cards and a
: punch clock if you want to track labour times

Agreed, I can use a keyboard recorder to pull up my browser,login me in
before 8:00am everyday. Is this company hiring? <smile>

Don
: write a program like a screen saver that kicks off the operator on a
: set time interval with inactivity, launch on each workstation at
: logon script
:
: "Porky" <sc*****@noemail.net> wrote in message
: news:#L**************@tk2msftngp13.phx.gbl...
::
::
:: Scenario: login/logoff scripts that kick username, times, and dates
:: out to a CSV file. I have a linked table in access pointing to that
:: CSV file. Users typically log in and log out twice a day (they are
:: required by company policy to log out when they go to lunch).
::
:: Problem: I am trying to figure out a way to check when they logged
:: in first thing in the morning. Certain performance bonuses are
:: based on whether or not they logged into their systems before 8am
:: (once again, company policy). This needs to count the number of
:: times they are "late" (logged in after 8am) per week, and add it up
:: for the month (queries are typically on the calendar month). It
:: would be great if it could simultaneously go back and report on the
:: late times for the previous calendar quarter as well.
::
:: Thanks.
::
:: *** Sent via Developersdex http://www.developersdex.com ***
:: Don't just participate in USENET...get rewarded for it!

[Roland Hall]

"Don Verhagen" wrote:

In news:7r********************@golden.net,
Gung Ho <mi***********@netlane.com> typed:
Agreed, I can use a keyboard recorder to pull up my browser,login me in
before 8:00am everyday. Is this company hiring? <smile>

Don

If they are, the positions are probably hourly since exempt employees are
not usually subjected to this type of torment. No business I ever heard of
tried to track working hours for exempt employees. It would eliminate the
[company's] ability to exploit them into working overtime.

Would you really want to punch a time card?
--
Roland

This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose.

[William Tasso]

Roland Hall wrote:

...
Would you really want to punch a time card?

Only if I ever went back to hourly pay.

--
William Tasso - http://WilliamTasso.com

[Don Verhagen]

In news:uI**************@TK2MSFTNGP12.phx.gbl,
Roland Hall <nobody@nowhere> typed:
: "Don Verhagen" wrote:
:: In news:7r********************@golden.net,
:: Gung Ho <mi***********@netlane.com> typed:
:: Agreed, I can use a keyboard recorder to pull up my browser,login me
:: in before 8:00am everyday. Is this company hiring? <smile>
::
:: Don
:
: If they are, the positions are probably hourly since exempt employees
: are not usually subjected to this type of torment. No business I
: ever heard of tried to track working hours for exempt employees. It
: would eliminate the [company's] ability to exploit them into working
: overtime.

Exploit workers? Get out of here! ...Actually I don't get paid hourly,
however, I do track my hours myself. Every year, I determine how many ours
I have worked that would have been charged for overtime, if I worked hourly
and secondly for project purposes.
: Would you really want to punch a time card?

I really don't mind, either way. Like I said, time tracking has other
purposes than just for payroll. I.E. project management/billing.

Don

[Roland Hall]

"Don Verhagen" wrote:

Exploit workers? Get out of here!
Ya'. No companies ever did that.
...Actually I don't get paid hourly,
however, I do track my hours myself. Every year, I determine how many ours I have worked that would have been charged for overtime, if I worked hourly and secondly for project purposes.
.... and then what do you do with it?
: Would you really want to punch a time card?

I really don't mind, either way. Like I said, time tracking has other
purposes than just for payroll. I.E. project management/billing.

Do you bill inter-departmental?

--
Roland

This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose.