# Bps to Gbit/Hour Calculator - Convert Bytes Per Second to Gigabits Per Hour

## Conversion History (Last 6)

### Excel Formula to convert from Bps to Gbit/Hour

Apply the formula as shown below to convert from Bytes Per Second to Gigabits Per Hour.

A | B | C | |
---|---|---|---|

1 | Bytes Per Second (Bps) | Gigabits Per Hour (Gbit/Hour) | |

2 | 1 | =A2 * 0.000000008 * 3600 | |

3 |

Download - Excel Template for Bytes Per Second to Gigabits 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 Gbit/Hour Conversion

You can use below code to convert any value in Bytes Per Second to Gigabits Per Hour in Python.

bytesPerSecond = int(input("Enter Bytes Per Second: "))

gigabitsPerHour = bytesPerSecond * 8 / (1000*1000*1000) * 60 * 60

print("{} Bytes Per Second = {} Gigabits Per Hour".format(bytesPerSecond,gigabitsPerHour))

gigabitsPerHour = bytesPerSecond * 8 / (1000*1000*1000) * 60 * 60

print("{} Bytes Per Second = {} Gigabits Per Hour".format(bytesPerSecond,gigabitsPerHour))

The first line of code will prompt the user to enter the Bytes Per Second as an input. The value of Gigabits Per Hour is calculated on the next line, and the code in third line will display the result.