How to How to Use MINUTE Function in Excel in Excel - Practical Guide

Learn how to use the MINUTE function to extract minutes from time values in Excel. This function isolates the minute component (0-59) from any time format, essential for analyzing time data, calculating durations, and creating time-based reports. Perfect for scheduling, time tracking, and data transformation tasks.

Why This Matters

Extracting minutes from timestamps is crucial for time analysis, payroll calculations, and scheduling tasks in business operations. Mastering MINUTE enables efficient time-based data manipulation and reporting.

Prerequisites

•Basic Excel knowledge and familiarity with cell references
•Understanding of time format and serial numbers in Excel

Step-by-Step Instructions

Open Excel and Select Your Target Cell

Launch Excel and click on the cell where you want the minute result to appear, for example cell C2.

Enter the MINUTE Function Syntax

Type =MINUTE(A2) where A2 contains your time value (e.g., 14:35:22 or 2:45 PM).

Press Enter to Execute

Press Enter to confirm the formula and display the extracted minute value (0-59) in your cell.

Copy the Formula Down (Optional)

Select cell C2, copy it (Ctrl+C), then select the range C3:C10 and paste (Ctrl+V) to apply to multiple rows.

Verify Results

Check that extracted minutes are correct and adjust cell formatting if needed via Home > Number Format > Number.

Alternative Methods

Using TEXT Function

Use =TEXT(A2,"mm") to extract and format minutes as text. This approach offers formatting flexibility but returns text instead of a numeric value.

Combining with HOUR and SECOND

Extract all time components separately using HOUR, MINUTE, and SECOND functions, then combine with concatenation or arithmetic for advanced time analysis.

Tips & Tricks

✓MINUTE always returns a numeric value between 0 and 59, regardless of the input time format.
✓Combine MINUTE with HOUR and SECOND functions to deconstruct complete timestamps for detailed analysis.
✓Use MINUTE in conditional formulas (IF, SUMIF) to filter or calculate based on minute values.

Pro Tips

★Use MINUTE with MOD function to calculate minute intervals: =MOD(MINUTE(A2),15) identifies 15-minute blocks.
★Nest MINUTE within IFERROR for robust time handling: =IFERROR(MINUTE(A2),"") prevents errors from invalid times.
★Combine MINUTE with SUMPRODUCT to count occurrences of specific minutes within a dataset.

Troubleshooting

MINUTE function returns #VALUE! error

This occurs when the input cell contains text or invalid time data. Verify the cell contains a valid time format (e.g., 14:35) or use TIME function to convert serial numbers.

MINUTE returns 0 for all entries

Check if your time values are stored as text rather than actual time values. Convert text times to real times using VALUE() or TIME functions.

Formula displays as text instead of executing

Ensure the cell is formatted as General or Number (not Text). Right-click cell > Format Cells > Number tab > select General or Number category.

Related Excel Formulas

HOUR SECOND TIME NOW TODAY TIMEVALUE TEXT

Frequently Asked Questions

What does the MINUTE function do in Excel?

The MINUTE function extracts the minute component (0-59) from a time value. It returns a numeric value representing only the minutes, ignoring hours and seconds.

Can MINUTE work with time values stored as text?

Generally no. If times are stored as text, wrap them with VALUE() or TIMEVALUE() functions first: =MINUTE(TIMEVALUE(A2)). Always verify your time data is in proper Excel time format.

How do I extract minutes, hours, and seconds separately?

Use HOUR(), MINUTE(), and SECOND() functions on the same time cell. For example: =HOUR(A2) for hours, =MINUTE(A2) for minutes, =SECOND(A2) for seconds.

Can MINUTE handle 24-hour and 12-hour time formats?

Yes, MINUTE works regardless of time format display. It extracts the minute value the same way whether the time shows as 14:35 or 2:35 PM.

What happens if I apply MINUTE to a date cell?

MINUTE will return 0 because dates without time components have no minutes. Only apply MINUTE to cells containing time values or datetime values with time components.