Automatically exclude 1 hour lunch break

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.

Hey ramananhrm!

Thanks for the help!

But there's just one problem with the formula you made. What I had in mind was for the time between 12:00AM to 1:00PM excluded altogether even if the time log was like the sample I posted previously. Is there any way that you can help me with that?

Appreciate your help.

Hey


I think this may help you. see the attachment n follow the steps if your problem is still persist then upload your excel file with some more details...

Hey amarjeet.it!

Thanks for your idea. I still can't figure this out.

I attached a sample for what I need in to get done.

Thanks for the help pips.

Hey samaine,

Hope this will help you for sure...

you must enter time in correct format as AM or PM which is required accordingly...

Hey guys!

Thanks for all your help. I finally found the right formula for the daily time record that I'm tasked to do. Thanks so much for all your help.

Till next time!

Welcome...


if your task is done then not to forget to mark this post as "solved" from Thread tools option