MINUTE

• How to use MINUTE formula?
• Examples of using MINUTE formula
• MINUTE formula not working?
• Similar formulas to MINUTE

Usage

Use the MINUTE formula with the syntax shown below, it has 1 required parameter:

=MINUTE(time)

1. time (required):
   The date or time value that you want to extract the minute from. This can be entered as a reference to a cell containing a date or time value, or as a date or time value enclosed in double quotes.

Examples

Calculating minutes worked

If you have a start time and an end time for a task, you can use the MINUTE function to calculate the number of minutes worked. Subtract the start time from the end time, then use the MINUTE function to extract the minutes from the result.

Extracting minutes from a timestamp

If you have a timestamp that includes hours and minutes, you can use the MINUTE function to extract the minutes from the timestamp. This can be useful if you want to group events by minute.

Calculating time differences

If you have two timestamps and you want to calculate the time difference between them in minutes, you can use the MINUTE function in combination with other date and time functions.

Common Mistakes

Incorrect argument format

One common mistake is providing an argument that is not a valid time format. Ensure that the argument provided is a valid time format or use the TIME function to create one.

Using non-date/time values

Another mistake is using non-date/time values as the argument for MINUTE. This will result in an error. Ensure that the argument provided is a date/time value.

Not referencing a cell with a time value

Another mistake is not referencing a cell with a time value. Ensure that the argument provided is a cell reference that contains a valid time value.

Related Formulas

The following functions are similar to MINUTE or are often used with it in a formula:

• HOUR

  The HOUR function returns the hour component of a given time. This function is most commonly used to extract the hour value from a timestamp or a time value. The function takes one parameter, which is the time to extract the hour component from.

• SECOND

  The SECOND function takes a time value and returns the seconds component of that time as a number between 0 and 59. This function is most commonly used to extract the seconds portion of a time value in order to perform calculations or comparisons based on seconds.

• DATEVALUE

  The DATEVALUE formula in Google Sheets converts a date string into a date value that Google Sheets can recognize as a date. This formula is commonly used when data is imported or copied into Google Sheets from other sources that may not recognize date values. The formula can be used to convert a variety of date string formats into a date value that Google Sheets can work with.

• TIMEVALUE

  The TIMEVALUE formula in Google Sheets is used to convert a time string into a time value in the format of HH:MM:SS. This formula is often used to extract the time value from a date/time string and use it for further calculations or formatting.

Learn More

You can learn more about the MINUTE Google Sheets function on Google Support.