+ Reply to Thread
Results 1 to 3 of 3

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

  1. #1
    Registered User
    Join Date
    05-11-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    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


    with this great answer
    =(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. #2
    Valued Forum Contributor Saarang84's Avatar
    Join Date
    02-19-2009
    Location
    Chennai, India
    MS-Off Ver
    XL 2003 to 2010
    Posts
    812

    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.
    If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.

    If your requirement has been solved please mark your thread as Solved.
    In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".

    Kindly use [FORMULA] or [CODE] tags when posting your code.

    Regards,
    Sarang

  3. #3
    Registered User
    Join Date
    05-11-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculate vacation days taken or partial days
    By chris1965 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 07:18 PM
  2. Vacation Days Taken vs Vacation Days Scheduled
    By Gtrtim112 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2013, 02:44 PM
  3. Replies: 15
    Last Post: 06-17-2011, 03:37 PM
  4. Replies: 9
    Last Post: 09-03-2007, 08:26 PM
  5. Keeping track of Sickdays, Vacation days, and hours for each.
    By Mike in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-15-2006, 03:10 PM

Bookmarks

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