View Single Post
  #1   Report Post  
kc sunshine
 
Posts: n/a
Default Formula for calculating time

I am establishing a Timesheet for our business in Excel. I have cells for
"In" , "Lunch Out", "Lunch In" and "Out" that employees will enter their
times (in military time). Need the formula that will calculate the total
hours for the day, subtracting out for the lunch break.

Thanks!