MINUTE

Get the minute as a number (0-59) from a time

Sponsored Link

MINUTE

Purpose 

Get the minute as a number (0-59) from a time

Return value 

A number between 0 and 59.

Syntax 

=MINUTE (serial_number)

Arguments 

  • serial_number - A valid time in a format Excel recognizes.

Usage notes 

Times can be supplied as text (e.g. "7:45 PM") or as decimal numbers (e.g. 0.5, which equals 12:00 PM).

Excel stores dates and times as serial numbers. For example, the date Jan 1, 2000 12:00 PM is equal to the serial number 32526.5 in Excel. To check that Excel is correctly recognizing a date or time, you can temporarily format the date as a number.

Sponsored Link

0 votes. 0 / 5