Calculate time passed only if a cell meets specific criteria

[angeloudaki]

Working out time.

How do I use a column to calculate only if a cell contains specific criteria? e.g. Only calculate difference between start and end time if the category is "Accrued" otherwise use "0"

[TABLE="width: 400"]
<colgroup><col width="80" span="5" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl65, width: 80"]Category[/TD]
[TD="class: xl65, width: 80"]Start[/TD]
[TD="class: xl65, width: 80"]End[/TD]
[TD="class: xl65, width: 80"]Accrued[/TD]
[TD="class: xl65, width: 80"]Used[/TD]
[/TR]
[TR]
[TD="class: xl66"]Accrued[/TD]
[TD="class: xl67"]09:25[/TD]
[TD="class: xl67"]09:40[/TD]
[TD="class: xl68"]00:15[/TD]
[TD="class: xl65"]0[/TD]
[/TR]
[TR]
[TD="class: xl66"]Used[/TD]
[TD="class: xl67"]16:00[/TD]
[TD="class: xl67"]17:00[/TD]
[TD="class: xl65"] 0[/TD]
[TD="class: xl68"]01:00[/TD]
[/TR]
</tbody>[/TABLE]

I tried an 'If' but I can't make it work

 

[gaz_chops]

Try

=if(A2="Accrued",C2-B2,0)

 

[angeloudaki]

Try

=if(A2="Accrued",C2-B2,0)

Like a dream! Thank you!

 

[gaz_chops]

You're welcome.

 

[jtakw]

Hi,

If you table is as shown in OP, D2 formula copied down and across to calculate Both "Accrued" and "Used":

Book1
	A	B	C	D	E
1	Category	Start	End	Accrued	Used
2	Accrued	9:25	9:40	0:15	0:00
3	Used	16:00	17:00	0:00	1:00
Sheet487

Cell Formulas
Range	Formula
D2	=IF($A2=D$1,$C2-$B2,0)