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


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:

Google Sheets if time is greater than formula

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

One Reply to “Google Sheets: Formula for “If Time is Greater Than””

  1. hmm, there’s some conflict of interest with the NOW() function.
    I’m trying to make a cell that results in “before” if it’s before noon, otherwise “after”.
    If I compare to a cell with NOW() at 11:00 AM, the formula returns “after”.
    But if I compare to a cell where I manually type in “11:00”, the formula returns “before”.
    Strange.

Leave a Reply

Your email address will not be published. Required fields are marked *