Adding Time

[cummingsea]

I need to add up some times in A2 to A 32 I have dates (1/1/22 to 1/31/22)
in B2 Start, C2 Stop, D2 Start, E2 Stop, F2 Start, G2 Stop, H2 Start, I2 Stop, J2 Start, K2 Stop and in L2 Total Hours
I need it to add B3 07:00, C3 08:00, D3 14:00, E 15:05 and so on and add up the hours in L3 2:05 (2H 5M)
Thank you for your help in advance.

 

[Alex Blakenburg]

Will this work for you ?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Start	Stop	Start	Stop	Start	Stop	Start	Stop	Start	Stop	Total Hours
2	1/11/2022	10:00	12:00	13:00	14:00	15:00	16:05	18:00	18:30	19:00	21:00	6:35
3	2/02/2022	7:00	8:00	14:00	15:05							2:05
Sheet1

Cell Formulas
Range	Formula
L2:L3	L2	=SUMIFS($B2:$K2,$B$1:$K$1,"Stop")-SUMIFS($B2:$K2,$B$1:$K$1,"Start")

 

[cummingsea]

Thank you for the reply that worked great, once again Thank you

 

[Alex Blakenburg]

You're welcome. Glad I could help.