MINUTE (Converts a serial number to a minute)

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.

Related Information

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

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

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