MINUTE Function in Excel with Example

MINUTE ()

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.

Best view in desktop mode.

	A	B	C	D
1	Different Format Time	Minute
2	2/19/2020 21:17	17	=MINUTE(A2)
3	9:15:00 PM	15	=MINUTE(A3)
4	0.02	28	=MINUTE(A4)
5	0.52	28	=MINUTE(A5)
6	1.52	28	=MINUTE(A6)
7

Syntax

=MINUTE(serial_number)

 

Formatting

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

Example

Bar Clock – Showing the system time (10:57:35 PM) with bars.

	A	B	C	D	E	F
1	Clock
2	Hour	|||||||||||||||||||||| 22
3	Minute	||||||||||||||||||||||||||||||||||||||||||||||||||||||||| 57
4	Second	||||||||||||||||||||||||||||||||||| 35
5		=REPT("|",HOUR(NOW()))&" "&TEXT(HOUR(NOW()),"00")
6		=REPT("|",MINUTE(NOW()))&" "&TEXT(MINUTE(NOW()),"00")
7		=REPT("|",SECOND(NOW()))&" "&TEXT(SECOND(NOW()),"00")

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() function as the basis for the number of repeats.

To update the clock press the function key F9.

Time Conversion

To convert a time from HH:MM format to Decimal format.

	A	B	C	D
1	Enter a time in HH:MM format :	2:45
2	The same time converted to a decimal :	2.75	=B1*24
3	To extract the hours as a decimal :	2	=INT(B1*24)
4	To extract the minutes as a decimal :	0.75	=MOD(B1*24,1)
5

To convert a time from Decimal format to HH:MM format.

	A	B	C	D
1	Enter a time in decimal format :	3.75
2	The same time converted to HH:MM :	3:45	=B1/24
3	To extract the hours in HH:MM :	3:00	=INT(B1)/24
4	To extract the minutes in HH:MM :	0:45	=MOD(B1,1)/24
5

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

SECOND in Excel

<<  Previous

Next  >>

HOUR in Excel