[Solved] Need help on calculating my salary

[Tallrot]

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.

[Villeroy]

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

[Tallrot]

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

[kingfisher]

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

[Tallrot]

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