Hey guys and gals, I have just joined this forum and hopefully I will not be disappointed.
I am creating a small program using Excel to help me calculate what I am going to get paid on payday every fortnight. To be honest, the only thing I (barely) know how to do is make the table on Excel with pretty words.
I am a teenager and get $x per hour. On Sundays I make $double x and if I work after 6pm I make $x + $1/2 x.
What I want to make is a table based on the hours I have worked that tallies up all the hours, does all the calculations (after 6pm or sunday work) and creates a grand total as well.
So for example, if I work 6 hours on a Monday from 1:00pm to 19:00 (7:00pm) and 7 hours on a Sunday from 11:00 to 18:00 (6:00pm). I would like a table where I can just put them times in (24 hour preffered) and I would instantly get how much I get paid.
I have created a rough table and uploaded it to a free website to show you what my layout is.
http://www.uploading.com/files/YMW0V...s_Pay.xls.html
As you can see, I have 9 columns and 5 rows. The slots with the hour times are where I insert what hours I have worked. The "Total $" row is where it will tell me how much I get for that day (added from both days of that fortnight). So for example, the two Monday hours will be calculated into my hourly rate of pay, added up together and come up in the Total $ row. Sunday of course being the double hourly pay day and after 6pm on any day being normal pay + 1/2 of normal pay.
The grand total box is pretty much self explanatory (all the Total $ days added together).
----------------
I hope you understand all that if you decide to help me, I am having trouble making the formulas for each column/row and especially having trouble telling excel that the hours after 6pm have to be changed to a new rate.
If there are any questions on parts you don't understand, please ask by replying to this thread.
Bookmarks