View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mj mj is offline
external usenet poster
 
Posts: 78
Default Adding hours in Excel

Hello
I am trying to create a timesheet which tracks the total hours worked in a
day along with overtime. I don't want to show the lunch break but I want to
factor it in.
ex.
Start 7 AM
End 6 PM
Total Hours 10 Hours (1hr for lunch)

I also want to be able to track the hours per week based on a 50 hr work week.

Any suggestions would be appreciated.

Thanks in advance