start and end times with 3 different lunch scenarios!

tjlutz

New Member
Joined
Jul 3, 2012
Messages
33
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

12/9/2017
3:00 PM
10:30 PM
7.5

<colgroup><col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> </colgroup><tbody>
</tbody>
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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!
 
Upvote 0
What you could do is underneath the 7.5 enter the formula...

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

Change the ranges to suit.

I hope this helps!
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,034
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top