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.
