Help with simple (I think) spreadsheet

J

jtees4

Hi. I am trying to do this for work and can't seem to get it.
I hope my example makes some sense and thank you all in advance for
any help you may be able to give me.


COLUMNS
A=DATE (weekending date)
B=HOURS WORKED THAT WEEK
C=AMOUNT DUE (Pay rate in column J X COLUMN B)
D=AMOUNT PAID (Of the total weekly amount due)
E=AMOUNT OWED (Amount owed for the week)
F=BLANK
G=PAYMENT DATE
H=PAYMENT AMOUNT (payments are made whenever for various amounts)
J=PAY RATE per hour

Each week I fill in hours worked that week. It will automatically
calculate what is owed based on B X J. Payments are made whenever cash
is available, payments do not necessarily exactly match amounts owed.
When I imput an amount paid in column H, I need columns D and E to
calculate automatically.

If anyone needs specific information I can send an Excel file to
anyone interested in helping. It's simple I know...but I have hit a
roadblock for some reason. Thank you all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top