ok, I suck at excel- even with an "Excel for Dummies" book.....
I have four columns: first one has start time- second one has time break started-third one has time break ended- and the fourth has end time
I want the fifth column to have the total hours worked that day. I thought that a simple: C15+F15-(D15+E15) would do the trick- not so much
can anyone help me with how to make this work? And also this is a biweekly time sheet, so I would have to write this for each row with it's respective letters?
time sheet.png
Bookmarks