Help determining when users are late

P

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.
 
G

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
 
D

Don Verhagen

In Gung Ho <[email protected]> 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
:
: ::
::
:: 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.
::
::
:: Don't just participate in USENET...get rewarded for it!
 
R

Roland Hall

Don Verhagen said:
In Gung Ho <[email protected]> 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.
 
D

Don Verhagen

In Roland Hall <nobody@nowhere> typed:
: "Don Verhagen" wrote:
:: In :: Gung Ho <[email protected]> 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
 
R

Roland Hall

Don Verhagen said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
474,141
Messages
2,570,817
Members
47,366
Latest member
IanCulpepp

Latest Threads

Top