The MINUTE returns the the minutes of a time value. The minute is given as an integer, ranging from 0 to 59.

MINUTE takes 1 required argument and no optional arguments:

Syntax: MINUTE(serial_number)

#1)
Using the MINUTE function:
#2)
The arguments for the MINUTE function are:
Argument Required? Description
serial_number Required The time that contains the minute you want to find. Times may be entered as text strings within quotation marks (for example, "7:30 AM"), as decimal numbers (for example, 0.3125, which represents 7:30 AM), or as results of other formulas or functions (for example, TIMEVALUE("7:30 AM")).

Summary

The MINUTE returns the the minutes of a time value. The minute is given as an integer, ranging from 0 to 59.
comments powered by Disqus