Time Sheets (Yes, I've already done a search on previous posts)

  • Thread starter Thread starter LM813
  • Start date Start date
L

LM813

I am trying to set up a kind of unique time sheet - I want it to have 3
in/out times, and a total number of HOURS worked per day. This is what
I want it to look like:

B C
Time In: 8:00 AM
Time Out: 12:00 PM
Time In: 12:30 PM
Time Out: 4:00 PM
Time In: 5:30 PM
Time Out: 7:00 PM

Total hours: _____

Could someone help me with a formula, please?:confused:
 
total hours =(C2-C1)+(C4-C3)+(C6-C5)
OF COURSE you may have to adjust the format for time
 
Back
Top