Syntax
MINUTE(serial_number)
| Parameter | Description |
|---|---|
| serial_number | Parameter of the MINUTE function. |
Examples
Get minutes from time
Formula
=MINUTE("3:45 PM")
Returns 45 — the minutes portion of 3:45 PM.
Round to quarter hour
Formula
=TIME(HOUR(A1), FLOOR(MINUTE(A1), 15), 0)
Rounds the time down to the nearest 15-minute interval. 3:47 PM becomes 3:45 PM. Useful for timesheet rounding.
Total minutes from midnight
Formula
=HOUR(A1)*60 + MINUTE(A1)
Converts a time to total minutes since midnight. 2:30 PM returns 870 (14*60+30). Useful for duration calculations.
Common Errors
#VALUE!
Occurs when the argument is not a valid time or datetime value.
Tips
Returns 0-59
MINUTE always returns an integer from 0 to 59. It extracts only the minutes component, not total elapsed minutes.
For total minutes, use math
To get total minutes between two times: =(B1-A1)*1440 (1440 = minutes per day). MINUTE only gives you the minutes component.
Timesheet rounding
=MROUND(A1, TIME(0,15,0)) rounds to the nearest 15 minutes. =FLOOR(A1, TIME(0,15,0)) rounds down. Common for payroll applications.
Try MINUTE in Viztab
Import your data and use MINUTE with 370+ other formulas. No signup required.
Open Viztab