bps to EiB/Hour Calculator - Convert Bits Per Second to Exbibytes Per Hour
Conversion History (Last 6)
Quick Navigation
- bps to EiB/Hour - Conversion Diagram, Formula and Steps
- Excel Formula to convert from bps to EiB/Hour
- bps to EiB/Hour Conversion Table
- How to use bps to EiB/Hour Calculator
- Difference between Bits Per Second to Exbibytes Per Hour
- Frequently Asked Questions (FAQs)
- Complete list of Bits Per Second Converters
bps to EiB/Hour - Conversion Formula and Steps
Bit and Exbibyte are units of digital information used to measure storage capacity and data transfer rate. Bit is one of the very basic digital unit where as Exbibyte is a binary unit. One Exbibyte is equal to 1024^6 bytes. There are 9,223,372,036,854,775,808 Bits in one Exbibyte. - view the difference between both units
| Source Data Unit | Target Data Unit |
|---|---|
|
Bit (b)
Equal to 0 or 1
(Basic Unit) |
Exbibyte (EiB)
Equal to 1024^6 bytes
(Binary Unit) |
The formula of converting the Bits Per Second to Exbibytes Per Hour is represented as follows :
Now let us apply the above formula and, write down the steps to convert from Bits Per Second (bps) to Exbibytes Per Hour (EiB/Hour).
- STEP 1 → Exbibytes Per Hour = Bits Per Second / (8x10246) x 60 x 60
- STEP 2 → Exbibytes Per Hour = Bits Per Second / (8x1024x1024x1024x1024x1024x1024) x 60 x 60
- STEP 3 → Exbibytes Per Hour = Bits Per Second / 9223372036854775808 x 60 x 60
- STEP 4 → Exbibytes Per Hour = Bits Per Second x (1 / 9223372036854775808) x 60 x 60
- STEP 5 → Exbibytes Per Hour = Bits Per Second x 0.0000000000000000001084202172485504434007 x 60 x 60
Example : If we apply the above steps, conversion from 10 bps to EiB/Hour, will be processed as below.
- = 10 / (8x10246) x 60 x 60
- = 10 / (8x1024x1024x1024x1024x1024x1024) x 60 x 60
- = 10 / 9223372036854775808 x 60 x 60
- = 10 x (1 / 9223372036854775808) x 60 x 60
- = 10 x 0.0000000000000000001084202172485504434007 x 60 x 60
- = 0.0000000000000039031278209478159624252
- i.e. 10 bps is equal to 0.0000000000000039031278209478159624252 EiB/Hour.
(Result rounded off to 40 decimal positions.)
You can use above formula and steps to convert Bits Per Second to Exbibytes Per Hour using any of the programming language such as Java, Python or Powershell.
Excel Formula to convert from bps to EiB/Hour
Apply the formula as shown below to convert from Bits Per Second to Exbibytes Per Hour.
| A | B | C | |
|---|---|---|---|
| 1 | Bits Per Second (bps) | Exbibytes Per Hour (EiB/Hour) | |
| 2 | 1 | =A2 * 0.0000000000000000001084202172485504434007 * 3600 | |
| 3 |
Download - Excel Template for Bits Per Second to Exbibytes Per Hour Conversion
If you want to perform bulk conversion locally in your system, then download and make use of above Excel template.
Python Code for bps to EiB/Hour Conversion
You can use below code to convert any value in Bits Per Second to Exbibytes Per Hour in Python.
exbibytesPerHour = bitsPerSecond / (8*1024*1024*1024*1024*1024*1024) * 60 * 60
print("{} Bits Per Second = {} Exbibytes Per Hour".format(bitsPerSecond,exbibytesPerHour))
The first line of code will prompt the user to enter the Bits Per Second as an input. The value of Exbibytes Per Hour is calculated on the next line, and the code in third line will display the result.