#1
|
|||
|
|||
spreadsheet/excel question
alright, here is the deal. i have a spreadsheet with my winnings and how much time i played for each session. i want to get my hourly rate in another cel. it wont let me just do simple division to find it...does anybody know how i can do this?
-mike |
#2
|
|||
|
|||
Re: spreadsheet/excel question
It depends on how your playing time is entered in the sheet. The easiest way is if you enter it in decimal hours, i.e. 1.2 hours, 2.0 hours, etc.
If you playing time is in A1 through A10 and your winnings are in B1 through B10, the hourly $ rate is: =(SUM(B1:B10) / SUM(A1:A10)) |
|
|