# Two criteria to calculate

#### Ks1102

##### Well-known Member
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

### Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

#### pagrender

##### Well-known Member
I'm not exactly sure what you are asking.

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:

#### Ks1102

##### Well-known Member
I'm not exactly sure what you are asking.

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:
pagrender

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 ....

1,106,819
Messages
5,513,584
Members
408,960
Latest member
dichthuatco