calculating hours minus lunches

[toshiba1]

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!

 

[Bill H]

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)?

 

[greeman]

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

 

[nbrcrunch]

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

 

[cblincoln43]

time sheet

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