# Gbps to GB/Hour Converter - CONVERT Gigabits Per Second to Gigabytes Per Hour

Copy Link & Share### Excel Formula to convert from Gbps to GB/Hour

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

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

1 | Gigabits Per Second (Gbps) | Gigabytes Per Hour (GB/Hour) | |

2 | 1 | =A2 * 0.125 * 3600 | |

3 |

Download - Excel Template for Gigabits 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 Gbps to GB/Hour Conversion

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

gigabitsPerSecond = int(input("Enter Gigabits Per Second: "))

gigabytesPerHour = gigabitsPerSecond / 8 * 60 * 60

print("{} Gigabits Per Second = {} Gigabytes Per Hour".format(gigabitsPerSecond,gigabytesPerHour))

gigabytesPerHour = gigabitsPerSecond / 8 * 60 * 60

print("{} Gigabits Per Second = {} Gigabytes Per Hour".format(gigabitsPerSecond,gigabytesPerHour))

The first line of code will prompt the user to enter the Gigabits 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.