Hello,

I am new to using formulas in spreadsheets. I have managed to set my columns to HH:MM time format. Now I want to structure my spreadsheet with employee names in the far left column, followed by begin time, and end time. I will need to subtract 1 hour for lunch for any shift over 6 hours. I then want to sum the times per employee per day, and time per day total. The times per employee will end up being in a column to the right of their schedule. The time per day will end up in a row below the columns for day of the week. Where the times per employee and times per day totals intersect I want a total of hours for the week. Please help me to grasp the formulas needed.