MINUTE

Return the minutes, 0 to 59, from a time value.

Syntax

MINUTE(serial_number)

Argument	Required	Description
`serial_number`	Required	A time, expressed as a fraction of a day.

Examples

Every example below was executed against VisiGrid engine 0.35.0 — not transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.

Formula	Result	Notes
`=MINUTE(0.53125)`	`45`	0.53125 of a day is 12:45.
`=MINUTE(0.75)`	`0`
`=MINUTE(TIME(12,45,0))`	`45`	Built with TIME rather than a hand-written fraction.

Getting a readable fraction

Minutes are awkward to write as day fractions, so build the time rather than typing a decimal:

=MINUTE(TIME(12,45,0))     → 45

The arithmetic version — (12 + 45/60) / 24 — gives the identical value, and is worth recognising in inherited spreadsheets written before TIME existed.

Rounding matters either way. A stored value a hair under the exact fraction reports the previous minute, so derive times rather than transcribing decimals by hand.

Excel compatibility

Matches Excel.