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