# bps to TiB/Hour Calculator - Convert Bits Per Second to Tebibytes Per Hour

## Conversion History (Last 6)

### Excel Formula to convert from bps to TiB/Hour

Apply the formula as shown below to convert from Bits Per Second to Tebibytes Per Hour.

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

1 | Bits Per Second (bps) | Tebibytes Per Hour (TiB/Hour) | |

2 | 1 | =A2 * 0.0000000000001136868377216160297393798828 * 3600 | |

3 |

Download - Excel Template for Bits Per Second to Tebibytes 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 TiB/Hour Conversion

You can use below code to convert any value in Bits Per Second to Tebibytes Per Hour in Python.

bitsPerSecond = int(input("Enter Bits Per Second: "))

tebibytesPerHour = bitsPerSecond / (8*1024*1024*1024*1024) * 60 * 60

print("{} Bits Per Second = {} Tebibytes Per Hour".format(bitsPerSecond,tebibytesPerHour))

tebibytesPerHour = bitsPerSecond / (8*1024*1024*1024*1024) * 60 * 60

print("{} Bits Per Second = {} Tebibytes Per Hour".format(bitsPerSecond,tebibytesPerHour))

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