Formula to Subtract Time if Over a Value

[Choolio123]

Hey there. I am a novice Excel user and I am basically making a spreadsheet to help manage employees hours at my job on campus. Basically the employees get a 30 minute unpaid break if they work over 6 hours. I have two columns, starting and ending time, both in the 12:00 AM format. I have a third column that I want to calculate the time between them. (Essentially OUT_TIME - IN_TIME). I want it to basically subtract 30 minutes if the shift is over 6 hours. So if someone works from 12:00 PM to 5:30 PM, the third column should display 5:30 (5 hours and 30 minutes), but if they work from 12:00 PM to 7:00 PM, I want it to show 6:30 (6 hours and 30 minutes) because of their unpaid break. How would I do this? I'm stuck.

Thanks.

[Special-K]

I'm sure there's a neater way to do this...

=IF(B1-A1>TIMEVALUE("06:30:00"),TIMEVALUE("06:30:00"),B1-A1)

[Special-K]

...and this could be it

=MIN(B1-A1,TIME(6,30,0))

[bebo021999]

With A1: In, B1: Out time (A1 and B1 in a same day)

=B1-A1-(B1-A1>6/24)*1/48

[Choolio123]

With A1: In, B1: Out time (A1 and B1 in a same day)

=B1-A1-(B1-A1>6/24)*1/48

I had to modify it to be greater than or equal to instead of greater than. It worked perfectly. Awesome. You guys are great!