Tracy,

Not sure if you got a solution but this worked for me. Not sure if
it's the most efficient but it worked.


=(B2+60/24)-A2-(0&C2)

Where B2 is the End Time, A2 is the Start Time and C2 is the lunch
time. One of the problems with your data is that :30 is not recognized
as a time so I used the 0& to make excel recognize it. Even if the
lunch time is 1:00, it will work.

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=505465