Originally Posted by

**Marc Fleury**
"Summer" <summer@thecabinbythelake.com> wrote in

news:_vFve.1209$Q75.165416@newshog.newsread.com:

> Wait a minute. Is someone checking to see if we're awake here?

>

> How can someone clock out at 12:00 but yet have lunch from 11:45 to

> 12:15? The formula gives the wrong answer in this case. 3 hours less

> 30 minutes for lunch equals 2:30 worked, not 2:45. At least that's how

> it works in my sample xls.

>

> Am I the one who's mistaken here?

Maybe the formula is only meant to track work done on a specific

project, instead of work done all day. So it would be possible for the

lunch time to either be contained either fully, partially, or not at

all during the project work time.

The formula that I would use it

=IF(C1>B1,B1-A1,IF(D1<A1,B1-A1,((MAX(A1:D1)-MIN(A1:D1))-(D1-C1))))

For

A1 B1 C1 D1

start end lunchstart lunchend

translated:

if lunchstart is later than project end, work time is just start to end

if lunchend is earlier than project start, work time is just start to

end

otherwise, worktime is the difference between the earliest and latest

times on the board, minus the time spent on lunch

--

Marc.

## Bookmarks