Hi everyone!

Can someone help me?

I have to create a schedule which incorporates lunches automatically. The schedule only has time in and time out, but I need excel to automatically deduct the lunch break between 12:00 am to 1:00 pm.

I can't put lunch breaks seperately, so all I have to work with is Time in/out in AM and PM and the total hours. I have a problem with computing the total hours in a day automatically if the time log ends up like this:

AM = 8:00 to 12:20
PM = 12:55 to 5:00

Also, I wouldn't be able to use military time, so I don't know how excel can assume that time in is in the morning, and time out is in the evening and/or half-day.

Please help.