# late or tardy

Status
Not open for further replies.

#### UPN

##### Board Regular
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

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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

yes

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

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.

Replies
10
Views
418
Replies
1
Views
368
Replies
3
Views
269
Replies
1
Views
158
Replies
2
Views
329

1,219,959
Messages
6,151,153
Members
451,011
Latest member
Pigdog89

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back