Thanks:  0
Likes:  0

# Thread: Calculate Working hour excluding Lunch time

1. ## 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. ## 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.

3. ## 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`

4. ## Re: Calculate Working hour excluding Lunch time

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

## User Tag List

#### Posting Permissions

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