Assume...
'In' is Cell B2
'Out' is Cell C2
'In After Lunch' is Cell D2

Time to leave would be calculated as...
=+D2+(8/24)-(C2-B2)
Format in Military time if desired.
(8/24) indicates 8 hours worked out of 24 is time to leave!
HTH,
--
Gary Brown

If this post was helpful to you, please select 'YES' at the bottom of the
post.



"Nicholas Scarpinato" wrote:

Hello. I've got a spreadsheet that calculates the time I've worked for the
two weeks of each pay period and approximate pay for those weeks. However, I
just came across the goal seeker function and it gave me this great idea, I
want to be able to put in the time I clocked in, the time I clocked out for
lunch, and the time I clocked back in from lunch, and have the computer tell
me what time my 8 hours are up. (I'm not allowed to go over 40 in a week, but
my schedule is flexible in that I can arrive early and take short lunches and
leave early, etc.) I know I can goal seek this but I want to have a formula
to do it for me so I don't have to. I'm currently entering the time in in
military time, so I don't know if that makes a difference or not.