Time and day sheet

[John Smucker]

Here I have a spreadsheet where we are trying to find the average days that employees worked in one year.. Attached I have an example of the Sheet (January).
If the column "Start time" contains either Pd Holiday, Pd Vacation, or Pd Sick, I want it to return the value of a full day (9.00 Hrs.) or if it does not contain any of these and contains a time value instead I want it to calculate the duration between "Start time" and "Finish time"
Now, if column "Start Time" contains Nonpaid Holiday, Nonpaid Sick, or Nonpaid Vacation I want it to return 0.00
What formula should I use to tie all these together?
Paid Holiday,Sick, and Vac or calculate time duration or if Nonpaid Holidays Sick or Vac return 0.00

 

[mackc557]

I included conditions in case the values are in End Time cell.

Book1
	A	B	C
2	8:45 AM	5:00 PM	8.25
3	Nonpaid Holiday		0.00
4	Pd Holiday		9.00
Sheet1

Cell Formulas
Range	Formula
C2:C4	C2	=IF(OR(OR(A2="Pd Holiday",A2="Pd Vacation",A2="Pd Sick"),OR(B2="Pd Holiday",B2="Pd Vacation",B2="Pd Sick")),9,IF(OR(OR(A2="Nonpaid Holiday",A2="Nonpaid Vacation",A2="Nonpaid Sick"),OR(B2="Nonpaid Holiday",B2="Nonpaid Vacation",B2="Nonpaid Sick")),0,(B2-A2)/0.0416666666666667))

 

[John Smucker]

Thank you!
I made a few changes but this helped me understand the if and or function...