[Solved] Determine pay, given rate and minutes worked

[downtownjb5]

(SOLVED)Hello. Can anyone help me with a formula i need. Here's what I'm doing.
i need the cell to give me the sum of .28 x ? (? being a certain number of minutes) = __________.
Example: job pays $17/hr so the .28 is what $17/hr pays per minute. so if someone works 3 hrs and 40 minutes, i need a formula that would give me what that 40 minutes total is so I can add it to the total hours and come up with a TOTAL pay . Hopefully that makes sense.

[Zizi64]

Please upload your ODF type sample file here. We must see the data types and the structures in your file. Modify the sensitive contents to some dummy data in a copy of your file.

[FJCC]

The best way to handle this, I think, is to enter the hours and minutes in a single cell. For example, select cell A1 and then choose the menu Format -> Cells. On the Numbers tab, set the Category to Time and set the Format to the one with the Format Code HH:MM. On my system this is the first entry in the Format list and it is displayed as 13:37. Now enter 3:40 in A1. In B1 enter 17. In C1 enter

Code: Select all

=A1 * B1 * 24

C1 will display 62.333. The reason for multiplying by 24 is that time is stored in units of Days, so to convert from Days to Hours I multiplied by 24.

[RusselB]

Where did you get your .28 from?
$17/hr = 28 1/3 cents per minute. Close to your .28, but not exactly the same.
When calculating a pay, someone paying attention will notice the difference between $17/hr for 3 hours 40 minutes ($62.33) and $0.28/minute ($61.60)
Calculating a total pay knowing the amount of time and the pay rate is just a simple multiplication. Due to the fact that spreadsheets use time as fractions of a day, your formula would be something like

Code: Select all

=A1*17*24

where A1 is the time (eg 3:40)

[downtownjb5]

Wow, thats great. You're right, I should have given you all the info I had. My idea is to be able to set up a simple spreadsheet for people to fill in their info and then the total just works out . bottom line is they make $17/hr and then i have to take off 20% for taxes and then add mileage paid at .54 cents per mile so the toal I owe them is ?. Thats what i need the spreadsheet to tell me. they would come in and fill in how many hours they worked and how many miles they drove and it would spit out the total I owe. Phew. is that possible.

[downtownjb5]

thanks to all who are helping me.

[RusselB]

You already have a formula for calculating the time.
Multiply the result of that formula by .2 to get the 20% for taxes
You'll need another entry for the mileage, then multiply that by .54 (I hope that's supposed to be 54 cents, not .54 cents/mile)
If you have the time in column B and mileage in column C, the total you are asking for can be in column D using

Code: Select all

=B2*17*24-current()*.2+C2*.54

I suspect, that, most of the time, this will not return a number that is proper for dollars & cents (ie: rounded to 2 decimal places)
The rounding can be done by wrapping the entire code using the ROUND function. This would be my preference, but some people/systems want more detail than 2 decimal places, as there will end up being a rounding discrepancy.

[downtownjb5]

THANK YOU TO ALL....