Help with a function/formula

[julievandermeulen]

I need help writing a function/formula

Dropbox

www.dropbox.com

in tab Sheet 3
in cell D7
I want it to subtract .5 if there is a "x" in Cells A2:A5 but I can't figure it out.

 

[julievandermeulen]

Thank you. I need the subtotals for Quickbooks. But I may try this formula in another workbook I have.

 

[Peter_SSs]

I need the subtotals for Quickbooks. But I may try this formula in another workbook I have.

I'm not certain what you are saying but it sounds like you are suggesting that my formula does not produce the results you want?
If it is just that you don't want the grand total included, then the formula (to still produce all the other results at once) would be

25 03 29.xlsm
	A	B	C	D	E	F
1	lunch	time in	time out	total time
2		08:00	09:00	1		s
3	x	09:00	11:00	2		s
4		11:00	11:30	0.5		r
5		11:30	12:00	0.5		b
6			Total
7			r	0.5
8			s	2.5
9			b	0.5
Sheet3 (2)

Cell Formulas
Range	Formula
D7:D9	D7	=BYROW(C7:C9,LAMBDA(rw,SUM((F2:F5=rw)*((C2:C5-B2:B5)*24-(A2:A5="x")*0.5))))
Dynamic array formulas.