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.
Only the fraction part of the number is used as it is this which relates to time of day.
Syntax
=MINUTE(Number)
=MINUTE(Number)
Formatting
The result will be shown as a normal number between 0 and 59.
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.
Related Information
The three formula above have also been formatted as hh:mm using
58 the Format, Cells, Number, Time command.