[Solved] Need help on calculating my salary

[Solved] Need help on calculating my salary

I'm running open office calc on win xp and I would need some help on constructing a spreadsheet that calculates my salary.
The basic salary is 10 €/hour and then more money is added on the following days and hours:

monday-thursday 6 pm - 6 am: 4 €
friday/saturday 6 pm - 6 am: 6 €
saturday 6 am - midnight: € 10
sunday: € 10

I want to do a spreadsheet where I just add my hours and it will calculate the salary for me. Thanks alot in advance.
Last edited by Hagar Delest on Mon Jun 09, 2008 5:45 pm, edited 2 times in total.
Reason: tagged the thread as solved.
Tallrot

Posts: 5
Joined: Fri May 16, 2008 3:45 pm

Re: Need help on calculating my salary

Your table has gaps. Do you mean:
sunday 00:00 to mon 6 am: € 10
monday-thursday 6 am - 6 pm: 4 €
thursday 6 pm - saturday 6 am: 6 €
saturday 6 am - sunday midnight: € 10
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

Villeroy
Volunteer

Posts: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Need help on calculating my salary

I'll write the tables in 24 hour instead since we're both from europe

monday-thursday 18:00-06:00: 4 €
fri/sat 18:00-06:00: 6 €
saturday 06:00-24:00: 10 €
Sunday(The entire day): € 10

Please note that these numbers are added to the usual salary of € 10, if the hours are outside this table the salary is only € 10/hour
Tallrot

Posts: 5
Joined: Fri May 16, 2008 3:45 pm

Re: Need help on calculating my salary

Enter the rates as the total rates at which you are paid, the number of hours worked at each rate, multiply then add.
Apache OpenOffice 4.1.6 on PCLinuxOS

kingfisher
Volunteer

Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: Need help on calculating my salary

I think I solved it now, thanks for the help.
Tallrot

Posts: 5
Joined: Fri May 16, 2008 3:45 pm