<p>Let X be hashes per second, and Y be the difficulty. Let Z be the Log base 1-1/(2^32*Y) of 1/2. Z is how many hashes it will take you to find a block, on average. Let A be the current block reward (it's currently 25). Let B be the number of seconds in a 24-hour day: 86,400. You will earn, on average, A*X*B/Z bitcoins per day.</p>

CC BY-SA 3.0
2017-06-16T15:29:26.123Z
The simplest explanation I've found so far. Nice!.
Batman
CC BY-SA 3.0
2013-05-10T00:18:06.480Z
2013-05-10T00:18:06.480Z
lurf jurv
<p>I have seen other formulas, but they all vary and don't work. Can someone please show me a formula where I can plug in the difficulty and hash rate and that will give me how many bitcoin I generate in a day.</p>

<p>I know there are online calculators, but I want a formula for a spreadsheet.
Thank you to all replies.</p>

<mining-profitability>
Formula for calculating daily mining earnings
cjmaria
# Formula for calculating daily mining earnings

(Asked by: username_0 on 2013-05-09)

I have seen other formulas, but they all vary and don't work. Can someone please show me a formula where I can plug in the difficulty and hash rate and that will give me how many bitcoin I generate in a day.

I know there are online calculators, but I want a formula for a spreadsheet.
Thank you to all replies.

**Tags:** mining-profitability


---

## 1 answers

### Answer by username_1 on 2013-05-10. Score: 5 | Accepted answer

Let X be hashes per second, and Y be the difficulty. Let Z be the Log base 1-1/(2^32\*Y) of 1/2. Z is how many hashes it will take you to find a block, on average. Let A be the current block reward (it's currently 25). Let B be the number of seconds in a 24-hour day: 86,400. You will earn, on average, A\*X\*B/Z bitcoins per day.

> **Comments:**
> **username_2**: The simplest explanation I've found so far. Nice!.  

---

