• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

MINUTE in Excel

September 9, 2021 by Andrew Childress
Minute in Excel

Excel spreadsheets are useful tools to work with many kinds of data. It's useful to extract the minute from a given time. Here's how to use MINUTE in Excel.

Excel spreadsheets are useful tools to work with many kinds of data. This data can take a variety of forms, like a time. Sometimes, it’s useful to extract the minute from a given time. Fortunately, Excel offers an easy way to do exactly that. Let’s learn how to use MINUTE in Microsoft Excel.

How to Use MINUTE in Excel

Let’s imagine that you have a list of times in an Excel spreadsheet. For example, cells C2, C3, and C4 contain the times 9:53 AM, 10:07 PM and 1:40 PM. Of course, these times contain both hours and minutes. You may want to see only the minutes, listed in separate cells as 53, 7, and 40.

Of course, you could input this data manually simply by typing the numbers above. But imagine if you had a list of 500 times. Working manually would take far too long! This is where Excel’s MINUTE function comes in, to help you calculate in minutes.

To use MINUTE, click into an empty cell. You can use any cell in your spreadsheet, but we’ll choose D2 to place the minute value immediately beside the full time.

Then, type an = sign. This tells Excel that you’re typing a formula into the selected cell. Continue by inserting the MINUTE function:

=MINUTE(

Minute in Excel

Click into the cell containing the first time value, C2, type ), and your formula will be complete:

=MINUTE(C2)

Minute formula in Excel

Hit Enter on your keyboard, and cell D2 will display the value 53.

From here, you can click and drag the lower right corner of cell D2 downward into cells D3 and D4. This will copy your MINUTE function to extract the minute value from the other two cells.

Minute function Excel

As you can see, MINUTE in Excel is a fast and simple way to work with time values. It saves you precious time if you want to extract minutes from longer times.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Workday formula in ExcelWORKDAY in Excel
Next Post:Hide Zeroes in ExcelHide zeroes in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top