Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

MINUTE

Find minute component from a timevalue in Excel
Converts a serial number to a minute

Rational

Find minute component from a timevalue.

Description

The Excel MINUTE function returns the minute component of a time value or timestamp (integer from 0 to 59) of the corresponding time. For example, with a time of 6:48 PM or text (e.g. “6:48 PM”), =MINUTE(time) will return ’48’.

Syntax

= MINUTE(serial_number)

Parameters

serial_number – A valid argument of time, string representation or a serial number of a specific time recognized by Excel.

Return Value

An integer between 0 and 59.

Key Notes

  • Time value in the function may be entered in time, text and serial number format in the specific cell of the worksheet.
  • Time is stored as a serial number in Excel, a number from 0 (12:00:00 AM) to 0.999988426 (11.59:59 PM). Like 0.65 = 24*.65 = 15.6, return as .6*60 (minute) = 36, using MINUTE function.
  • Use SECOND and HOUR functions to return other two components of Timestamp.

Keep Reading Similar Functions:

Returns the seconds component from a time value in Excel

SECOND

The SECOND function returns the second component (a number from 0 to 59). Example, 6:48:15 PM, the SECOND function will return ‘15’.

Read More »
Returns current date and time in Excel.

NOW

The NOW function returns the serial number of the current date and time. Example; to show the current date and time, use NOW(), empty parenthesis.

Read More »
Find hour component from a time value in Excel

HOUR

The Excel HOUR function returns the hour component of a timestamp between 0 (12:00 A.M.) and 23 (11:59 P.M.), use =HOUR(0.3) that returns ‘7’ (0.3*24).

Read More »