Month question!

[lazor99]

Thanks for your time,

How would i keep track of employee hours in the first payrole (first 15 days only)and then reset number and keep track of 2nd payrole hours of the same month (last 15 days).

A1:A365 = Date
B1:B365 = Employee Hours entered daily

Note: Some months have 31 days or 16 days in 2nd payrole

Thanks for your help.

 

[Tazguy37]

How exactly did you want to "keep track" of the entries?

You can try using the DAY() function to give you the day of the month for a date.

Here's an example:

Book1
	A	B	C	D
1	Date	Hours		Total Hours 15th-EOM
2	11/8/2005	8		38.5
3	11/9/2005	10
4	11/10/2005	11
5	11/11/2005	8
6	11/12/2005	8
7	11/13/2005	9
8	11/14/2005	8
9	11/15/2005	8
10	11/16/2005	11
11	11/17/2005	10
12	11/18/2005	9.5
Sheet1

Formula in D2 is (array entered):
=SUM(IF(DAY(A2:A12)>=15,B2:B12,0))

Hope that helps!

 

[lazor99]

Sorry about the bad post,

Dates Employee hours
Ex: A1 = 11/06/2005 B1 = 10.0
A2 = 11/07/2005 B2 = 5.0
A3 = 11/08/2005 B3 = 8.0
A4 = 11/09/2005 B4 = 8.0
A5 = 11/10/2005 B5 = 7.0
A6 = so on and so on. B6 = so on and so on

How do i sum employee hours for the first 15 days and then reset the number and sum employee hours for the 2nd payrole week (last 15 days)