start and end times with 3 different lunch scenarios!

[tjlutz]

Hi Guys! I'm having a little difficulty with this problem. I have 3 different lunch times depending upon hours of work. They are: 5 hrs, no lunch; 5.5-6.5 hrs, 30 minute lunch; 7+ hrs, 1 hr lunch. So I'm trying to be able to merely punch in my start:end times and have the formula calculate my actual paid work time without the meal times being factored in. Thanks so much for the help. I had a couple of videos I was watching but couldn't find anything with the 3 scenarios. Thanks again for the help! By the way, I'm trying to work horizontally on my spread sheet

<colgroup><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> </colgroup><tbody>
[TD="class: xl63, width: 75, align: right"]12/9/2017[/TD]

[TD="class: xl64, align: right"]3:00 PM[/TD]

[TD="class: xl64, align: right"]10:30 PM[/TD]

[TD="class: xl65, align: right"]7.5[/TD]

</tbody>

 

[S.H.A.D.O.]

Is the 7.5 in your example created using a formula?
If so, could you please post the formula and maybe we can adjust it accordingly.

I hope this helps!

 

[S.H.A.D.O.]

What you could do is underneath the 7.5 enter the formula...

=IF(A5>=7,A5-1,IF(A5>5,A5-0.5,A5))

Change the ranges to suit.

I hope this helps!