*31*

You can use the following formula to create an IF statement that compares the time in a cell to some specific time in Google Sheets:

**=IF(B2>TIME(0, 5, 0), "Slow", "Fast")
**

This particular formula checks the time in cell B2 and returns “Slow” if it is greater than 5 minutes or “Fast” if it is equal to or less than 5 minutes.

**Note**: The **TIME** function uses a format of **TIME(hours, minutes, seconds)**.

The following example shows how to use this formula in practice.

**Example: Formula for “If Time is Greater Than” in Google Sheets**

Suppose we have the following dataset in Google Sheets that shows the one-mile run times of various athletes:

We can use the following formula to check the time in cell B2 and return “Slow” if it is greater than 5 minutes or “Fast” if it is equal to or less than 5 minutes:

**=IF(B2>TIME(0, 5, 0), "Slow", "Fast")**

We can type this formula into cell **B2** and then click and drag it down to the remaining cells in column B:

For each athlete who has a time less than 5 minutes, the formula returns “Fast.”

For each athlete who has a time equal to or greater than 5 minutes, the formula returns “Slow.”

**Note**: You can find the complete documentation for the **TIME** function in Google Sheets here.

**Additional Resources**

The following tutorials explain how to perform other common operations in Google Sheets:

How to Convert Timestamp to Date in Google Sheets

How to Sort by Date in Google Sheets

How to Compare Dates in Google Sheets

How to Add Months to Date in Google Sheets