How do I total up a Military time card including deducting lunch?

[RudeBoy]

My cells are:
Time In
Out To Lunch
In From Lunch
Time Out

For Military format I am using 00\;00

Helpppppppppppppppp

 

[RudeBoy]

Ok I am getting CLOSER
I used this to get the Total for the Military time but I still need to take the hour off for lunch =J20-G20+(G20>J20)

G20=08:00 H20=13:00 I20=14:00 J20=17:00 so the formula calculated Military time & came up with 9 hrs which is correct. So now I need to somehow get the Lunch in there with the H20 & I20. Helpppppppppppppppp Thanks Take Care

 

[Tetra201]

Try this:

=MOD(J20-I20,1)+MOD(H20-G20,1)

 

[Logit]

.
Or this :

A​	B​	C​	D​	E​	F​
Time In​	Out Lunch​	In Lunch​	Time Out​		Total Hrs​
8:00​	12:00​	12:30​	16:30​	=​	8:00​
8:15​	12:10​	12:52​	17:34​	=​	8:37​
9:10​	11:45​	12:26​	16:15​	=​	6:24​
				=​	0:00​
				=​	0:00​
In F17 :​	=SUM(D17-A17)-(C17-B17)

<tbody>
</tbody>

Formula:

=SUM(D17-A17)-(C17-B17)

Edit ranges as required.

 

[RudeBoy]

This Worked Thanks =MOD(J20-I20,1)+MOD(H20-G20,1)
Take Care