{"id":1390,"date":"2018-07-04T10:49:42","date_gmt":"2018-07-04T10:49:42","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1390"},"modified":"2023-11-03T10:24:09","modified_gmt":"2023-11-03T10:24:09","slug":"minute","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/minute\/","title":{"rendered":"MINUTE function"},"content":{"rendered":"\n
The MINUTE Function returns the minutes of a given time in Excel.<\/p>\n\n\n\n
MINUTE(serial_number)<\/strong><\/p>\n\n\n\n The MINUTE function is used to extract the minute from a given time value. Here’s how you can use it:<\/p>\n\n\n\n Example 1:<\/strong> Extracting the minute from a specific time.<\/p>\n\n\n\n This formula will return 45, which is the minute portion of the time 12:45:30.<\/p>\n\n\n\n Example 2 (Optional):<\/strong> Using cell references.<\/p>\n\n\n\n If cell A2 contains a time value, this formula will return the minute portion of that time.<\/p>\n\n\n\n Example 3 (Optional):<\/strong> Extracting minutes from a datetime value.<\/p>\n\n\n\n This formula will return 30, which is the minute part of the datetime value “2023-11-03 14:30:00”.<\/p>\n\n\n\n Example 4 (Optional):<\/strong> Combining MINUTE with other functions.<\/p>\n\n\n\n This formula combines the MINUTE function with the TEXT function to format a time value in cell A2 and display it with the minute portion.<\/p>\n\n\n\n Example 5 (Optional):<\/strong> Handling date and time values together.<\/p>\n\n\n\n This formula creates a datetime value by combining the DATE and TIME functions and then extracts the minute part (30 minutes).<\/p>\n\n\n\n Remember that the MINUTE function only works with valid time values, and it will return an error if the input is not a recognized time format.<\/p>\n","protected":false},"excerpt":{"rendered":" The MINUTE Function returns the minutes of a given time in Excel. Syntax MINUTE(serial_number) Arguments serial_number The time from which you want to…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nArguments<\/h2>\n\n\n\n
serial_number<\/strong><\/td> The time from which you want to extract the minute.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to use<\/h2>\n\n\n\n
=MINUTE(\"12:45:30\")<\/code><\/pre>\n\n\n\n
=MINUTE(A2)<\/code><\/pre>\n\n\n\n
=MINUTE(\"2023-11-03 14:30:00\")<\/code><\/pre>\n\n\n\n
=TEXT(A2, \"hh:mm\")&\" has \"&MINUTE(A2)&\" minutes\"<\/code><\/pre>\n\n\n\n
=MINUTE(DATE(2023, 11, 3) + TIME(14, 30, 0))<\/code><\/pre>\n\n\n\n