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?
--
Summer (no valid email)


"anilsolipuram"
wrote in message
news:anilsolipuram.1r822b_1119769504.5024@excelfor um-nospam.com...
|
| formula should be
| A1 B1 C1 D1
| E1
| start end lunchstart lunch end answer
| 9:00 12:00 11:45 12:15 2:45
|
| formulae is
| =IF(C1B1,B1-A1,IF(AND(C1<B1,D1B1),B1-A1-(D1-B1),B1-A1-(D1-C1)))
|
|
| --
| anilsolipuram
| ------------------------------------------------------------------------
| anilsolipuram's Profile:
http://www.excelforum.com/member.php...o&userid=16271
| View this thread: http://www.excelforum.com/showthread...hreadid=382274
|