bps to GB/Hour Calculator - Convert Bits Per Second to Gigabytes Per Hour
Conversion History (Last 6)
Quick Navigation
- bps to GB/Hour - Conversion Diagram, Formula and Steps
- Excel Formula to convert from bps to GB/Hour
- bps to GB/Hour Conversion Table
- How to use bps to GB/Hour Calculator
- Difference between Bits Per Second to Gigabytes Per Hour
- Frequently Asked Questions (FAQs)
- Complete list of Bits Per Second Converters
bps to GB/Hour - Conversion Formula and Steps
Bit and Gigabyte 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 Gigabyte is a decimal unit. One Gigabyte is equal to 1000^3 bytes. There are 8,000,000,000 Bits in one Gigabyte. - view the difference between both units
| Source Data Unit | Target Data Unit |
|---|---|
|
Bit (b)
Equal to 0 or 1
(Basic Unit) |
Gigabyte (GB)
Equal to 1000^3 bytes
(Decimal Unit) |
The formula of converting the Bits Per Second to Gigabytes 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 Gigabytes Per Hour (GB/Hour). This way, we can try to simplify and reduce to an easy to apply formula.
Gigabytes Per Hour = Bits Per Second / (8x10003) x 60 x 60
Gigabytes Per Hour = Bits Per Second / (8x1000x1000x1000) x 60 x 60
Gigabytes Per Hour = Bits Per Second / 8000000000 x 60 x 60
Gigabytes Per Hour = Bits Per Second x (1 / 8000000000) x 60 x 60
Gigabytes Per Hour = Bits Per Second x 0.000000000125 x 60 x 60
Example : If we apply the above Formula and steps, conversion from 10 bps to GB/Hour, will be processed as below.
- = 10 / (8x10003) x 60 x 60
- = 10 / (8x1000x1000x1000) x 60 x 60
- = 10 / 8000000000 x 60 x 60
- = 10 x (1 / 8000000000) x 60 x 60
- = 10 x 0.000000000125 x 60 x 60
- = 0.0000045
- i.e. 10 bps is equal to 0.0000045 GB/Hour.
(Result rounded off to 40 decimal positions.)
You can use above formula and steps to convert Bits Per Second to Gigabytes Per Hour using any of the programming language such as Java, Python or Powershell.
Excel Formula to convert from bps to GB/Hour
Apply the formula as shown below to convert from Bits Per Second to Gigabytes Per Hour.
| A | B | C | |
|---|---|---|---|
| 1 | Bits Per Second (bps) | Gigabytes Per Hour (GB/Hour) | |
| 2 | 1 | =A2 * 0.000000000125 * 3600 | |
| 3 |
Download - Excel Template for Bits Per Second to Gigabytes 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 GB/Hour Conversion
You can use below code to convert any value in Bits Per Second to Gigabytes Per Hour in Python.
gigabytesPerHour = bitsPerSecond / (8*1000*1000*1000) * 60 * 60
print("{} Bits Per Second = {} Gigabytes Per Hour".format(bitsPerSecond,gigabytesPerHour))
The first line of code will prompt the user to enter the Bits Per Second as an input. The value of Gigabytes Per Hour is calculated on the next line, and the code in third line will display the result.