Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Calculate Working hour excluding Lunch time

  1. #1
    New Member
    Join Date
    Jan 2010
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calculate Working hour excluding Lunch time

    Hi Guys,
    I need help....I am working production scheduling with Start and End time but there is a lunch time and tea time. Is there any formula to calculate Start time to End time with excluding lunch time?
    Here is example :

    Lunch time :12:00pm to 1:00pm.
    Duration Process :6 hours.
    Start Time (8:00am)
    End time (5:00 pm)

    I need a formula to calculate from Start Time 8:00am and what is the End Time? with 1 hour lunch time...

    Thanks,
    ET

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,648
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Calculate Working hour excluding Lunch time

    Something like...


    =(B2 + (B2 < A2) - A2) - (1/24)

    where B2 is 5:00 PM and A2 8:00 AM.
    Assuming too much and qualifying too much are two faces of the same problem.

  3. #3
    Board Regular repairman615's Avatar
    Join Date
    Dec 2009
    Location
    Tennessee, USA
    Posts
    1,885
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculate Working hour excluding Lunch time

    Hello,
    Here is a simple example that may work for you.

    8:00 AM
    5:00 PM
    1:00
    6:00
    3:00 PM
    All formatted as time, 1:00 and 6:00 is just a different format (13:30)

    Then the formula for the 3:00 PM is:

    Code:
    =F7+F9+F10
    ___-Jeff______________

    - Posting guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Help using VBA Code
    - Helpful links from Hiker95

    Code Tags:
    [CODE] (Place your code here) [/CODE]
    ___-2007-

  4. #4
    New Member
    Join Date
    Jan 2010
    Posts
    15
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculate Working hour excluding Lunch time

    Hi Sir,
    Thanks...Is work....

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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