469,944 Members | 2,326 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,944 developers. It's quick & easy.

Help determining when users are late



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!
Jul 19 '05 #1
6 1680
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!

Jul 19 '05 #2
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!
Jul 19 '05 #3
"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.
Jul 19 '05 #4
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
Jul 19 '05 #5
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
Jul 19 '05 #6
"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.
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by abcd | last post: by
12 posts views Thread by Cliff Wells | last post: by
1 post views Thread by ian douglas | last post: by
3 posts views Thread by Starbuck | last post: by
15 posts views Thread by Jay | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.