For example, given a time of “7:45”, MINUTE will return 45.
The MINUTE function takes just oneargument,serial_number, which must be a validExcel dateor a validExcel time.
Times can be supplied to the MINUTE function as text (e.g.
“7:45 PM”) or as decimal numbers (e.g.
0.5, which equals 12:00 PM).
The MINUTE function will “reset” to 0 every 60 minutes (like a clock).
To work with minute values larger than 60, use a formula toconvert time to decimal minutes.
“7:45 PM”) or as decimal numbers (e.g.
0.5, which equals 12:00 PM).
In general, it’s best to use theTIME functionto create time values, because it reduces errors.
Note: Excel storesdatesandtimesas serial numbers.
The TIME function is useful when you want to assemble a proper time inside another formula.
