Calculating payroll hours

[Eric in Illinois]

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.

[RoryOF]

Commence by reading (4) in
viewtopic.php?f=75&t=39529

[Zizi64]

The Time, Date and DateTime content of the cells must be numeric values - if you want to make any calculation with them.

And it is better to use DateTime values instead of the Time values if the time values cover more then one day:
YYYY-MM-DD HH:MM:SS

Please upload your ODS type sample file here.

[Villeroy]

download/file.php?id=37974
download/file.php?id=1893