LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
J. Williams
 
Posts: n/a
Default Moving quarter attendance, please help?

How can I track attendance in ecel with a moving quarter? The following is an
example:
Employees will receive one (1) point for each full day absence without
regard to limit, and for any Leave of Absence (3 days or more) not covered
under FMLA. If an employee works less than one hour of their shift (unless
and extreme, verified medical problem or a verified emergency occurs), it
will be treated as a full day absence.

Employees will receive one half (1/2) point for each incident of late, leave
early, and leave early. and returns (Lesser incidents (4 minutes to 1 hour)
of late arrivals, leave early, leave early and return, and no punch or out
will be one quarter(l/4)point per incident) Also, a No Call(an employees
failure to daily notify the Company at least one (1) hour before the start of
their shift on the 24 hour Call-h Phone only, of the reason they are unable
to report for work), will be given and additional one-half( 1/2) point (**
Note: though still required to call at least one (1) hour before the start of
their shift the one-half (1/2) point will be assessed only If the call Is
made less than 30 minutes before the start of their shift).

The attendance programs progressive disciplinary action is listed below in
total number of incidents per moving quarter (90 days) or sooner.
Thanks in advance!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need cell formula to subtotal gross by month for a quarter mikeburg Excel Discussion (Misc queries) 4 November 7th 05 09:25 PM
Can a register automate a memo for none attendance? Crumm Excel Discussion (Misc queries) 1 August 25th 05 01:24 PM
Formula for current month minus one = Quarter number in a macro. Pank Excel Discussion (Misc queries) 11 June 22nd 05 02:47 PM
Date formula: return Quarter and Fiscal Year of a date Rob Excel Discussion (Misc queries) 7 May 11th 05 08:48 PM
Plotting moving average line on a chart Herbert Chan Charts and Charting in Excel 1 February 26th 05 08:31 PM


All times are GMT +1. The time now is 02:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"