I guess you intended =if(b2<a2,b2-a2+12+d2-c2,b2-a2+d2-c2) rather than
=if(b2<a2,a2-b2+12+d2-c2,b2-a2+d2-c2)?

Adding 12 is fine if the inputs are all numbers of hours (rather than
times), so if it were 1.5 rather than 1:30 your formula (as modified) would
work in those conditions, but I wouldn't recommend going down that route.
[If you did go that way, you may want to allow for coming back from lunch at
12:45?]
--
David Biddulph

"HARSHAWARDHAN. S .SHASTRI"
wrote in message
...
Hi Julie,

Let A is column for Start Time , B for leave for lunch,C for come back
from lunch and D for leave at the end then add this formula in column E
say
in cell E2.
=if(b2<a2,a2-b2+12+d2-c2,b2-a2+d2-c2)

Harshawardhan shastri

================================================== ===========

"Julie Holmberg" wrote:

What I need to do is have people enter the time they start, what time
they
leave for lunch, come back from lunch and leave at the end of the day. I
want Excel to automatically calculate the number of hours and minutes for
each of these so that I can then add up the total number of hours and
minutes
worked each day.
I am having a hard time formatting the cells (do I format them as time or
numbers?) and then whenever I try to add or subtract hours, how do you
deal
with the 12:00 hour, which then seems to mess up any formulas. For
example,
if someone clocks in at 7 and goes to lunch at 1:30 - how can you create
a
formula where Excel will get the correct answer of 6:30 minutes worked?
HELP!