View Single Post
  #1   Report Post  
Old March 26th 15, 11:40 AM posted to microsoft.public.excel.worksheet.functions
[email protected] bobbethel@gmail.com is offline
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2015
Posts: 1
Default Calculating my work hours minus lunch break and then adding forweekly total

I'm having trouble creating a time worksheet. I want to subtract my start time from my end time, determine if I have worked longer than 4 hours (company automatically takes 30 mins for a lunch break off total if you work more than 4 hours), and then calculate total house worked. I'm having a problem with the lunch break portion of the calculation. I need a formula that will work. What can I do??