# MBps to GiB/Hour Converter - CONVERT Megabytes Per Second to Gibibytes Per Hour

Copy Link & Share### Excel Formula to convert from MBps to GiB/Hour

Apply the formula as shown below to convert from Megabytes Per Second to Gibibytes Per Hour.

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

1 | Megabytes Per Second (MBps) | Gibibytes Per Hour (GiB/Hour) | |

2 | 1 | =A2 * 0.000931322574615478515625 * 3600 | |

3 |

Download - Excel Template for Megabytes Per Second to Gibibytes 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 MBps to GiB/Hour Conversion

You can use below code to convert any value in Megabytes Per Second to Gibibytes Per Hour in Python.

megabytesPerSecond = int(input("Enter Megabytes Per Second: "))

gibibytesPerHour = megabytesPerSecond * (1000*1000) / (1024*1024*1024) * 60 * 60

print("{} Megabytes Per Second = {} Gibibytes Per Hour".format(megabytesPerSecond,gibibytesPerHour))

gibibytesPerHour = megabytesPerSecond * (1000*1000) / (1024*1024*1024) * 60 * 60

print("{} Megabytes Per Second = {} Gibibytes Per Hour".format(megabytesPerSecond,gibibytesPerHour))

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