# calculating hours minus lunches

#### toshiba1

##### New Member
I need to know how I can calculate hours worked in excel. There are occassional days where a half break is taken for lunch, so how do I automatically deduct that from total hours at the end of the week, without having it disrupt the days where no lunch was taken?????
For example:
Monday - time in = 9:00am, time out = 5:12pm, no lunch taken
Tuesday - time in = 9:02am, time out = 5:17pm, half hour lunch taken
so how do I calculate the total hours worked minus lunches on specific days, and no lunch on other days??
I hope this makes sense!

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Hi Toshiba1 and welcome to the board!

A few questions...

How do you know whether or not they take lunch each day?
Are times entered when lunch begins and ends, or is 30 minutes simply assumed?
Do you need to know the exact amount of lunch time each day/week?
Is it possible that the workday could go past midnight?
What format do you want for the total times? Time format (40:00:00 hrs), or Decimal format (40.00 hrs)?

Could Try This

A1 Start Time in Time Format
B1 End Time in Time Format
C1 Time for Lunch in Gen Number Format
example 0= No Lunch; 0.5 = 1/2 hour; 1= 1 Hour
D1 = 24*(B1-A1)-C1

Use your browser's FIND (or SEARCH) function to find occurances of the word "time" on the following webpage. Several articles, Lots of reading

http://www.mrexcel.com/articles.shtml

time sheet

go to the mr excell above in (nbcrunch post) find Chip, calculating overtime.
Pearson site is great for this area.

Replies
1
Views
109
Replies
3
Views
244
Replies
1
Views
416
Replies
11
Views
708
Replies
6
Views
133

1,203,186
Messages
6,053,984
Members
444,696
Latest member
VASUCH

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back