Using AND functions with time

[homer11]

So here is my problem:

I am tracking when employees start working on a new job and when they complete it. I want to make an cell that calculates the total amount of time it took, but that also automatically deducts the time for breaks, lunch, and if it took more than one day.

Example:

Employee starts a job at 7AM Tuesday. He has a break from 8-8:10AM, lunch from 10:45-11:15am, another break from 1:00-1:10pm, goes home at 2:30pm, comes back at 6am, the next day, and finishes the job at 2PM on Wednesday. So i need a program that, in the case, would calculate the amount of hours between the two days and deducts the two lunches, four breaks, and at home time.

Any help is greatly appreciated.

[daffodil11]

Are you assuming they take two 10-Minute breaks and a 30-minute Lunch every day?

[daffodil11]

Here's one way you could design a time and tally form:

Attachment 261792