late or tardy

Status
Not open for further replies.

UPN

Board Regular
Joined
May 14, 2006
Messages
138
need formula for this

if you are late to clock in, you get a 1/3 of an occurance, one you have 3 late clock in you get a full occurance and then it starts over again

sample

5/24/06 1/3
6/25/06 1/3
7/1/06 1/3

you now have a full occurance

8/1/06 1/3

so total now you have 1 1/3 occurance

thanks in advance for any help
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Wouldn't a SUM formula work:
Book1
ABCD
1DateOccurrenceTotal
205/24/061/31 1/3
306/25/061/3
407/01/061/3
508/06/061/3
Sheet1


HTH,

Smitty
 

UPN

Board Regular
Joined
May 14, 2006
Messages
138
yes

yes it would, but what if i have to add the full occurance to another cell
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Re: yes

yes it would, but what if i have to add the full occurance to another cell

I'm not quite sure what you mean. I suppose you might be able to adapt SUMIF. Do you need to signify every full occurrence somewhere/how?

Smitty
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,113,993
Messages
5,545,378
Members
410,679
Latest member
rolandbianco
Top