Computing desk | ||
---|---|---|
< May 26 | << Apr | May | Jun >> | May 28 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
How can I accomplish this in Microsoft Excel 2016? This question concerns the proper operating with (and formatting of) time in Excel. Let's say that in Cell Number A1, I have a value of time. And in Cell Number B1, I want to specify a certain amount of time to add to (or subtract from) that initial time. And, in Cell Number C1, I want the resulting value. This is somewhat confusing (to me), since I am using the word "time" liberally, whereas I assume that Excel is much more precise. So, to clarify with an example:
So, how exactly would I format each Cell? And what exactly would I have to type into each Cell?
The Excel functions of "time" are very confusing to me, for many reasons (e.g., the way that Excel considers time, processes time, labels time, etc.) Very confusing. Hence, my questions.
And, again, I understand that in Cell Number A1 and Cell Number B1, I am using the same word, "time", even though I am referring to completely different concepts. That is: Cell Number A1 means "time of day", while Cell Number B1 means "number of minutes".
Thanks! Joseph A. Spadaro ( talk) 16:26, 27 May 2018 (UTC)
Thanks, all. Joseph A. Spadaro ( talk) 04:39, 31 May 2018 (UTC)
As I understand it, it has become more difficult to make money through mining Bitcoin, both because the rewards (as measured in Bitcoin) are lower and because the blockchains have become longer. This article indicates that the cost to mine a Bitcoin in the United States is $4,758, although the cost is lower in some other countries.
If the Bitcoin rewards for mining fell below the marginal cost of mining (which I assume is lower than the figure in the MarketWatch article), does that mean that the necessary blockchain validation would not be carried out, with potentially catastrophic implications for the viability of Bitcoin? To what extent would this concern be addressed by reductions in the cost of mining, as fewer people choose to engage in mining? John M Baker ( talk) 23:32, 27 May 2018 (UTC)
The bitcoin blockchain is large, about 130 GB today and may reach 1.5 - 1.6 TB in Jan. 2021. However a bitcoin miner does not need to store the whole blockchain (though he may do so as a "full node") because it is a collective function of the bitcoin network to keep all parts of the chain accessible on demand. A short or long blockchain hardly affects the miner's proof-of-work task which is essentially to provide 32 bits of a 640-bit message that can demonstrate a SHA-256 hash-of-hash value below a threshold set (to adjust difficulty) by the network. Corrected "hash-of-hash". DroneB ( talk) 12:57, 31 May 2018 (UTC)
Computing desk | ||
---|---|---|
< May 26 | << Apr | May | Jun >> | May 28 > |
Welcome to the Wikipedia Computing Reference Desk Archives |
---|
The page you are currently viewing is an archive page. While you can leave answers for any questions shown below, please ask new questions on one of the current reference desk pages. |
How can I accomplish this in Microsoft Excel 2016? This question concerns the proper operating with (and formatting of) time in Excel. Let's say that in Cell Number A1, I have a value of time. And in Cell Number B1, I want to specify a certain amount of time to add to (or subtract from) that initial time. And, in Cell Number C1, I want the resulting value. This is somewhat confusing (to me), since I am using the word "time" liberally, whereas I assume that Excel is much more precise. So, to clarify with an example:
So, how exactly would I format each Cell? And what exactly would I have to type into each Cell?
The Excel functions of "time" are very confusing to me, for many reasons (e.g., the way that Excel considers time, processes time, labels time, etc.) Very confusing. Hence, my questions.
And, again, I understand that in Cell Number A1 and Cell Number B1, I am using the same word, "time", even though I am referring to completely different concepts. That is: Cell Number A1 means "time of day", while Cell Number B1 means "number of minutes".
Thanks! Joseph A. Spadaro ( talk) 16:26, 27 May 2018 (UTC)
Thanks, all. Joseph A. Spadaro ( talk) 04:39, 31 May 2018 (UTC)
As I understand it, it has become more difficult to make money through mining Bitcoin, both because the rewards (as measured in Bitcoin) are lower and because the blockchains have become longer. This article indicates that the cost to mine a Bitcoin in the United States is $4,758, although the cost is lower in some other countries.
If the Bitcoin rewards for mining fell below the marginal cost of mining (which I assume is lower than the figure in the MarketWatch article), does that mean that the necessary blockchain validation would not be carried out, with potentially catastrophic implications for the viability of Bitcoin? To what extent would this concern be addressed by reductions in the cost of mining, as fewer people choose to engage in mining? John M Baker ( talk) 23:32, 27 May 2018 (UTC)
The bitcoin blockchain is large, about 130 GB today and may reach 1.5 - 1.6 TB in Jan. 2021. However a bitcoin miner does not need to store the whole blockchain (though he may do so as a "full node") because it is a collective function of the bitcoin network to keep all parts of the chain accessible on demand. A short or long blockchain hardly affects the miner's proof-of-work task which is essentially to provide 32 bits of a 640-bit message that can demonstrate a SHA-256 hash-of-hash value below a threshold set (to adjust difficulty) by the network. Corrected "hash-of-hash". DroneB ( talk) 12:57, 31 May 2018 (UTC)