I need some help in column B i put how many hours a person uses for PTO (Paid Time Off)
column A contains the date
this is the formula i have in column H
=SUMPRODUCT($B$7:$B$91,--(JULIAN>0),--(JULIAN<$AJ7+1))
Now i have to break it down by vacation or sick time
So in colum D I am going to put either a V or S so if it is V it will use the above formula and in a new column i am going to make for S
I guesss what i need is an IF Statement to add to the above formula and the new column for Sick time
Hope fully this example will show what i need
A B D H K
8/5 8.00 V 8.00 0.00
8/25 8.00 S 0.00 8.00
9/1 8.00 V 16.00 0.00
hope you understand what I am trying to do
Thanks in advance for any help
column A contains the date
this is the formula i have in column H
=SUMPRODUCT($B$7:$B$91,--(JULIAN>0),--(JULIAN<$AJ7+1))
Now i have to break it down by vacation or sick time
So in colum D I am going to put either a V or S so if it is V it will use the above formula and in a new column i am going to make for S
I guesss what i need is an IF Statement to add to the above formula and the new column for Sick time
Hope fully this example will show what i need
A B D H K
8/5 8.00 V 8.00 0.00
8/25 8.00 S 0.00 8.00
9/1 8.00 V 16.00 0.00
hope you understand what I am trying to do
Thanks in advance for any help