That's a little complicated for this lesson... you COULD do it, but it would be better to make TWO start and end times. You would have Start1, End1, Start2, End2 and then end the person's first shift at 12:30 and start it back up again at 1:00. The reason being is what if they took lunch from 12:45 to 1:15? Then it throws your logic off. Or, you could add a BREAK TIME field where you would just put in 30 minutes to be subtracted from the total.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Microsoft Excel 220.