Count consecutive absences with a limit

rhwong

Guest

Posts: n/a

18th Sep 2006

I have an attendance roster for the month and want to count the number of
absences. The problem I am having is that I can only count 5 consecutive
absences at one time. They can have 7 consecutive absences for one period and
then another set of absences for 5 days. That totals to 10 allowed absences
and 2 unallowed absences. How would you run a function to do this calculation
automatically.

« How do you subtract time as in a timecard to calculate hours work | Transfering a formula from one worksheet to another »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting consecutive absences	=?Utf-8?B?amVycnkzNzkxNw==?=	Microsoft Excel Worksheet Functions	6	9th Oct 2007 09:22 PM
Count Consecutive Dates	Laudrup	Microsoft Access	0	7th Mar 2007 01:08 AM
Count consecutive absences with a limit	rhwong	Microsoft Excel Worksheet Functions	7	20th Sep 2006 03:20 PM
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	6	29th Nov 2005 03:27 PM
Count Consecutive Numbers in a Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	4	19th Feb 2005 02:49 AM