On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Thursday, May 22, 2014

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.