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.