Page 1 of Help! Excel Driving me crazy! :p

General Forum

Help! Excel Driving me crazy! :p

zcool202 (Competent) posted this on Sunday, 26th June 2005, 19:50

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

Rich Johnson (Competent) posted this on Sunday, 26th June 2005, 21:00

If you can give me examples of column titles and example values I can probably work it out for you.

RE: Help! Excel Driving me crazy! :p

sj (Elite) posted this on Sunday, 26th June 2005, 21:02

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..

RE: Help! Excel Driving me crazy! :p

spartacus (Elite) posted this on Sunday, 26th June 2005, 21:56

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

zcool202 (Competent) posted this on Sunday, 26th June 2005, 22:20

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

Go back to General Forum threads, or All Forum threads