Work Time Sheets and Wages

  • Thread starter Thread starter AJakubisin
  • Start date Start date
A

AJakubisin

Please Help.

I am trying to set up a time sheet for work, because they keep shorting
me on hours. I figured that since I will be keeping track of my hours,
I should also project how much I am getting paid on a coming paycheck.

I am working a shift that often causes me to clock out past midnight
(0:00) and normally clock in at 16:00, to do this math I subtract 16:00
from 0:00 and add 24. But then when I try and multiply the total hours
for the day by my hourly wage I come up with numbers that do not make
sense. Such as working 7:56 and the multiplying by 15 and coming up
with 349.96, this is obviously not what I would be paid. I also can
not seem to add up hours from different days. I sum the column (8:00,
7:56, 8:16, 9:13, 7:45) and the answer comes out as 17:13, which is
once again abviously wrong. I am not sure how to achieve the correct
solution to my problem.:confused:
 
Don't overlook that you will also need to put in some IF statements to
handle your different overtime rules or if you get paid shift premiums
(Extra $$ for 3rd shift etc)
 
Back
Top