MINUTE

Formulas / MINUTE
Return the minute from a given time.
=MINUTE(time)
  • serial_number - required argument to find the minute

Examples

  • =MINUTE(A2)

    The MINUTE function can be used to extract the minutes from time values in Sourcetable. For example, the formula will return the minutes portion of the time in cell A2.

  • =MINUTE(A2)

    The MINUTE function can be used to calculate the total number of minutes for a given time. For example, if cell A2 contains the time 11:45:30, the formula will return 45.

  • =MINUTE(B2-A2)

    The MINUTE function can also be used to calculate the minutes between two times. For example, if cell A2 contains the time 12:00 and cell B2 contains the time 14:45, the formula will return 165, since the difference between the two times is 2 hours and 45 minutes.

Summary

The MINUTE function returns an integer from 0 to 59, which represents the minutes of a time value. This time value can be entered as a text string or decimal number.

  • The MINUTE function takes a valid date or time as its argument and returns a number between 0 and 59 minutes.
  • The MINUTE function can be used to get the minute into a cell, and can take text or decimal numbers as its time argument.
  • The MINUTE function resets to 0 every 60 minutes.


Frequently Asked Questions

What does the MINUTE function do?
The MINUTE function returns the minutes of a time value as a number.
What type of argument does the MINUTE function take?
The MINUTE function takes a time value as an argument. The time value may be entered as either a text string within quotation marks or as a decimal number.
What is a serial_number argument?
The serial_number argument is a time with the minute to find and is required for the MINUTE function to work correctly.
How do I use the MINUTE function?
The MINUTE function should be used in the following format: MINUTE(serial_number). The serial_number argument should be the time with the minute to find.
What other information do I need to use the MINUTE function?
You will need to know the time value you are looking to find the minutes of. This value may be entered as a text string within quotation marks or as a decimal number.

Related Functions

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.