Google Sheets - MINUTE function
MINUTE function returns the minute component of a time. Syntax MINUTE(time) Examples Notes If you have already used the 24-hour system such as "17:48:21", you should not add "PM" after it. "17:48:21 PM" is not regarded as a time but a general text. MINUTE("17:48:21 PM") gives a "#VALUE!" error.