MINUTE Function in MS-Excel

	C	D
3	Number	Minute
4	5/22/2014 21:56	56	=MINUTE(D4)
5	9:15:00 PM	15	=MINUTE(D5)
6	0.02	28	=MINUTE(D6)
7	0.52	28	=MINUTE(D7)
8	1.52	28	=MINUTE(D8)

What Does It Do?
The function will show the minute of the hour based upon a time or a number.
Only the fraction part of the number is used as it is this which relates to time of day.

Syntax
=MINUTE(Number)

Formatting
The result will be shown as a normal number between 0 and 59.

Example
The =REPT() function has been used to make a digital display for the current time.
The time functions of =HOUR(), =MINUTE() and =SECOND() have been used in conjunction with the =NOW() as the basis for the number of repeats.
To update the clock press the function key F9.

	C
26	Clock
27	Hour	|||||||||||||||||||||| 22
28	Minute	| 01
29	Second	|||||||||||||||||||||||||||||||||||||||||||||||| 48
		=REPT("|",HOUR(NOW()))&" "&TEXT(HOUR(NOW()),"00")
		=REPT("|",MINUTE(NOW()))&" "&TEXT(MINUTE(NOW()),"00")
		=REPT("|",SECOND(NOW()))&" "&TEXT(SECOND(NOW()),"00")

Related Information

To convert a time in hh:mm format to decimal format.

				F
38	Enter a time in hh:mm format :			2:45
40	The same time converted to a decimal :			2.75	=F38*24
42	To extract the hours as a decimal :			2	=INT(F38*24)
44	To extract the minutes as a decimal :			0.75	=MOD(F38*24,1)

To convert a time in decimal format to hh:mm format.

				F
49	Enter a time in decimal format :			3.75
51	The same time converted to hh:mm format is :			3:45	=F49/24
53	To extract the hours in hh:mm format :			3:00	=INT(F49)/24
55	To extract the minutes in hh:mm format :			0:45	=MOD(F49,1)/24

The three formula above have also been formatted as hh:mm using the Format, Cells, Number, Time command.