Menu
EXCEL MINUTE FUNCTION
Excel MINUTE Function Introduction
This function takes a time and extracts the minute as a number (0-59) and returns a number between 0 and 59.
Description of Excel MINUTE Function
Syntax:
=MINUTE (serial number)
List of parameters:
- serial number – a valid time in an Excel-compatible format.
Step By Step Guide of MINUTE Function
Key Points
- Times can be specified as text (for example, “7:45 PM”) or as decimal numbers (for example, 0.5, which equals 12:00 PM).
- Dates and times are stored as serial numbers in Excel.
- In Excel, for example, the date January 1, 2000 12:00 PM equals the serial number 32526.5.
- To ensure that Excel recognizes a date or time correctly, temporarily format the date as a number.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
