getting excel to give me a 'time to leave' time.

[Kyle Hogan]

You would think this fairly simple. I want to be able to plug in a
1)start time, a 2)lunch out time, 3) a lunch
return time, and then have exel tell me the the time to leave for an
8hr day. The problem comes in
trying to subtract the morning hours worked + lunch from a constant,
the 8. If I can get that to work, then
it should be fairly easy to add that onto the lunch return time to get
a clock out time.

 

[Bob Phillips]

Try

=start_time+"8:00:00"+(lunch_in-lunch_out)

HTH

Bob

 

[Peter Andrews]

Try

=start_time+"8:00:00"+(lunch_in-lunch_out)

HTH

Bob

I think that should be:

=start_time+"8:00:00"+(lunch_out-lunch_in)

Peter