Sum Time in groups?

[planetpj]

I have data that comes in in this format. It signifies working hours from ___ to ___. The sample only goes up to five days but the real one goes up to a full 31 days. I am using this formula right now =C2-B2+E2-D2+G2-F2+I2-H2+K2-J2 is there shortcut to this formula? so that I do not have to do this for 31 cell groups?

Thanks in advance PJ

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Name	1	1	2	2	3	3	4	4	5	5
2	X	8:00	8:30	4:30	5:30	3:30	4:00	4:30	5:30	7:30	8:30	4:00
3	Y											0:00
4	Z			3:30	5:30					2:30	6:00	5:30
Sheet1

 

[barry houdini]

Try

=SUM(B2:BK2)-SUMPRODUCT(--MOD(COLUMN(B2:BK2)-COLUMN(B2)+1,2),B2:BK2)*2

format as [h]:mm

 

[planetpj]

Thank you very much barry, worked like a charm!