Two criteria to calculate

[Ks1102]

Hi, experts

I wants have a formulas to found two criteria as column C = criteria and column D = time, example, found criteria “014”-“013” time.
The result on at cells A1,

Thanks

 

[pagrender]

I'm not exactly sure what you are asking.

Are you asking if:
C=some criteria, such as "014"
D=time, such as "013"
then give me the value that's in column A?

If so, here's that formula:
=IF(AND(C1="enter your criteria here",D1="enter your time here"),A1,0)

 

[Ks1102]

I'm not exactly sure what you are asking.

Are you asking if:
C=some criteria, such as "014"
D=time, such as "013"
then give me the value that's in column A?

If so, here's that formula:
=IF(AND(C1="enter your criteria here",D1="enter your time here"),A1,0)

pagrender

Thanks your reply and sorry the unclear asking, example here's

Cells A1 = 2:00

COL C COL D
011 10:00
012 10:30
013 13:15
017 16:00
014 15:15
068 17:21
else ....