trouble with if and text formula

[kyle_emp]

Hi I'm trying to put together a weekly schedule for work it would show the start time, finish time, and hours daily and then total the hours for the week. to total the hours daily I have been using the formula
=text(d6-c6,"h:mm")
the problem is that after working six hours an employee is allowed an unpaid 30 minute break so I've been trying to nest the previous formula into an if formulawhere if the result of the text formula is greater than 6 hours subtract 30 minutes. My problem is that I'm a novice excel user and still very new to if formulas as a result all I have been sucessful at is generating error messages. Any help would be greatly appreciated.

Many thanks
Kyle

 

[P Sitaram]

If A2 has the start time and B2 the finish time:

=B2-A2-((B2-A2)>=(6/24))*(1/48)

If there is a possibility of date change i.e., finish time being smaller than the start time, use:

=B2-A2+(A2>B2) -((B2-A2)>=(6/24))*(1/48)

You do not need to use the TEXT function. Just format the cell "h:mm"

 

[kyle_emp]

Thanks, every thing seems to be working fine

Kyle