Not that of a guru with excel but tryin to write a formula that will calculate total hrs worked for normal mon-fri 9a-5p week schedule. I have figured out how to calculate daily totals but for week total I would assume I need an "if" statement. I am not sure how to write this but would greatly appreciate some help.
thank you


Code:
Day	Time In	Time Out	Time In	Time Out	Total Hrs
mon	9:00	13:00	14:00	17:00
...