Page 1 of Help! Excel Driving me crazy! :p
General Forum
Any excel experts out there?
Trying to figure out how to calculate overall rate of pay/payroll in an excel document.
From rate of pay to the number of hrs and the total amount in pounds, but can`t figure out using time and numbers together. I must have missed this class in high school.
Anyone knows of any UK based templates in excel that I can borrow? :D
Cheers
RE: Help! Excel Driving me crazy! :p
If you can give me examples of column titles and example values I can probably work it out for you.
I think you`ll have to explain what you want a bit clearer.
Rate of pay in one cell, hours worked in another and in the other put =first cell reference*second cell reference.
Ste
We will pay the price but we will not count the cost..
Have a look here -
http://www.j-walk.com/ss/excel/files/general.htm
search for employee time sheet and just bastardise it to your needs.
Click on the protect sheet box to see the formulae.
Spartacus
This item was edited on Sunday, 26th June 2005, 23:03
RE: Help! Excel Driving me crazy! :p
Thanks for all the help guys,
It was to help calculate the hours and total rate for each day / week / month etc.
So it would look like...
¦ date ¦ start time ¦ end time ¦ breaks ¦ hours worked ¦ rate of pay ¦ ¦ total rate of day ¦
It's just the mixing of time and sums and currency that's mixing me up, never done it before.
The file you linked too looks promising Spartacus, thanks for that.
Cheers