November 8, 2018
We are trying to avoid buying a very costly time punch clock system at work, that tracks piecework and hours worked. So we are trying to write our own spreadsheet.
I have column I cell 5 highlighted, because it's not calculating right and I can't figure out what I'm doing wrong.
I have time in and time out columns and the difference. Giving me the number of hours doing that job. I have that calculating correctly.
I need to calculate # of pounds by $ rate per pound to equal Total $ for that job. in cell H5 I have the formula =F5*G5. That calculates correctly.
In cell I5 I need to calculate $25 divided by 6 hours but I keep getting $100 instead of $4.17. What am I doing wrong?
December 7, 2016
November 1, 2018