Thread: Time Sheet
View Single Post
  #1   Report Post  
S.E.
 
Posts: n/a
Default Time Sheet

I'm having an issue trying to find a formula that will work for the task I'm
trying to complete. I've created an Excel Spreadsheet...broken down into
Date columns, and the rows consist of "Time In, Time out, Time In, Time Out."
What I'm trying to do is at the end of every column have the time added up
and totaled, not including that middle timeout-timein (lunch period). For
each of the days of the week, then at the very end of the row that has the
daily total hours, I want to calculate the entire weeks total hours worked.
What formula's should I use to make this work?

Help!