Calculating payroll hours

Discuss the spreadsheet application

Calculating payroll hours

Postby Eric in Illinois » Sun Dec 29, 2019 7:15 pm

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.
Last edited by MrProgrammer on Sun Dec 29, 2019 8:43 pm, edited 1 time in total.
Reason: Moved topic from Beginners forum to Calc
Open Office 4.1.2 on Windows 10
Eric in Illinois
Posts: 1
Joined: Sun Dec 29, 2019 7:00 pm

Re: Calculating payroll hours

Postby RoryOF » Sun Dec 29, 2019 7:28 pm

Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
Posts: 31534
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calculating payroll hours

Postby Zizi64 » Sun Dec 29, 2019 7:32 pm

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:

Please upload your ODS type sample file here.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Posts: 9580
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calculating payroll hours

Postby Villeroy » Mon Dec 30, 2019 7:10 pm

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28641
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: fiona87 and 26 guests