[Solved] Need help on calculating my salary

Discuss the spreadsheet application

[Solved] Need help on calculating my salary

Postby Tallrot » Fri May 16, 2008 3:52 pm

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

Postby Villeroy » Fri May 16, 2008 5:31 pm

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
User avatar
Villeroy
Volunteer
 
Posts: 28544
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Need help on calculating my salary

Postby Tallrot » Fri May 16, 2008 10:48 pm

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

Postby kingfisher » Sat May 17, 2008 3:14 am

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
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: Need help on calculating my salary

Postby Tallrot » Sat May 17, 2008 12:58 pm

I think I solved it now, thanks for the help.
Tallrot
 
Posts: 5
Joined: Fri May 16, 2008 3:45 pm


Return to Calc

Who is online

Users browsing this forum: charlesjoseph, robleyd and 17 guests