Time Sheet Help

[Exodus129]

I am trying to set up a time sheet that would look like this:

2-Jan	3-Jan	4-Jan	5-Jan	6-Jan
6:00 AM	12:00 PM	6:00 AM	4:00 PM							#VALUE!

<tbody>
</tbody>

When I try and do a formula to have lunch taken out it breaks because I still do not completely understand what I am doing. I can take out lunch with =SUM(D29-C29-"00:30")+(F29-E29-"00:30")+(H29-G29-"00:30")+(J29-I29-"00:30")(L29-K29-"00:30") but I want to only subtract it on days that have more than 6 hours worked. I tried this one =SUM((D29-C29)*IF((D29-C29)>VALUE("6:00"),-"00:30"),"(D29-C29)") and it isnt working properly. Once I had this good I was going use it for each set of days in my SUM function to get total hours worked. Any assistance would be welcomed with open arms.<value("6:00"),-"00:30"),"(d28-c28)")< td=""></value("6:00"),-"00:30"),"(d28-c28)")<>

<tbody>
</tbody>

 

[texasalynn]

does this work
=IF((D29-C29)*24>6,((D29-C29)-TIME(,30,))*24,(D29-C29))

 

[Exodus129]

It gave me a result of 0 instead of what should have been 4 so it kinda worked.

3-Jan	4-Jan	5-Jan	6-Jan	7-Jan
6:00 AM	12:00 PM									0
		6:00 AM	4:00 PM							9:30

<colgroup><col><col><col><col><col><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

Driving me a little crazy currently...but thank you for trying.

 

[Exodus129]

In case anyone was looking at this for an answer, I got this formula to work for removing a 30 minute lunch for any work day over 6 hours and giving me the total time worked for the week.
=SUM(IF(F28-E28<1/24*6.1,F28-E28,F28-E28-1/48))+(IF(H28-G28<1/24*6.1,H28-G28,H28-G28-1/48))+(IF(J28-I28<1/24*6.1,J28-I28,J28-I28-1/48))+(IF(L28-K28<1/24*6.1,L28-K28,L28-K28-1/48)+(IF(N28-M28<1/24*6.1,N28-M28,N28-M28-1/48)))
Good Luck out there!