# Work Schedule that calculates hours, lunches, days off and vacation days

1. ## Work Schedule that calculates hours, lunches, days off and vacation days

I am trying to make a weekly work schedule for my employees that will show an In time, out time. Calculate the difference of hours with lunch breaks etc...

I found a post displayed below from 2009

I have to create a schedule which incorporates lunches automatically (either half hour or 1-hour lunches, depending on the circumstances).

The schedule only has time in and time out, but I need excel to automatically deduct the lunch break depending on the circumstance:

If you worked less than 6 hours = no lunch
If you worked more than 6 hours, but less than or equal to 8 hours = 0.5 hour lunch
If you worked more than 8 hours = 1 hour lunch

=(B2-A2)*24-IF((B2-A2)*24>8,1,IF((B2-A2)*24>6,0.5,0))

My problem is I need to do all this and also be able to have it Calculate "OFF" as 0 hours, and VAC as 8 hours. Is there some formula that can be combined with the one I found to accomodate my needs?

Thanks

2. ## Re: Work Schedule that calculates hours, lunches, days off and vacation days

Hi,

Welcome to the forum.

It would be helpful if you could post a sample time worksheet template, if any you have.

3. ## Re: Work Schedule that calculates hours, lunches, days off and vacation days

I attached a rough sample of how I would want it to be calculated per my description
Thanks

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1