MINUTE function
PRO
BASIC
The MINUTE
function in Jspreadsheet Formulas Pro is a tool that extracts the minute component from a given time value. It's presented as a whole number that can be anywhere from 0 to 59, corresponding to the minutes in an hour. This function is handy when you need to perform calculations or analysis involving the minute portion of time data in your Jspreadsheet.
Documentation
Returns the minute of a time value. The minute is given as an integer, ranging from 0 to 59.
Category
Date and time
Syntax
MINUTE(serial_number)
Parameter | Description |
---|---|
serial_number |
The time that contains the minute you want to find. |
Behavior
The MINUTE
function is designed to return the minute component of a particular time. The time is represented as a decimal number between 0 (12:00:00 AM) and 0.99999999 (11:59:59 PM).
Here is how MINUTE
handles different inputs:
-
Empty cells: If the
MINUTE
function is applied to an empty cell, it will return0
. -
Text: If the cell contains text that doesn't represent a date or time, the
MINUTE
function will return a#VALUE!
error. -
Booleans: If the cell contains a boolean value, the
MINUTE
function will treat it as0
forFALSE
and1
forTRUE
, and hence will return0
in both cases. -
Errors: If the referenced cell contains an error, the
MINUTE
function will return that error. -
Non-date values: If the cell contains numeric values that don't represent a date or time, the
MINUTE
function will treat it as a time serial number and may return unexpected results.
Common Errors
Error | Description |
---|---|
#VALUE! |
Occurs when the input cell contains text that doesn't represent a date or time. |
#REF! |
Occurs when the referenced cell is invalid. |
Best practices
- Always ensure that the input cell contains a valid date or time, as the
MINUTE
function can give unexpected results or errors with other types of data.- Be aware of the time serial number system used in spreadsheets, where
1
represents a 24-hour day. This can affect the result of theMINUTE
function.- Use the
HOUR
,MINUTE
, andSECOND
functions together to extract all time components from a date/time value.- Avoid using
MINUTE
function on cells containing error values as it propagates the errors.
Usage
A few examples using the MINUTE function.
MINUTE("2:30:15 PM") returns 30
MINUTE("9/1/2022 5:45:00 AM") returns 45
Interactive Spreadsheet Demo
<html>
<script src="https://jspreadsheet.com/v11/jspreadsheet.js"></script>
<script src="https://jsuites.net/v5/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v5/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v11/jspreadsheet.css" type="text/css" />
<link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Material+Icons" />
<script src="https://cdn.jsdelivr.net/npm/@jspreadsheet/formula-pro/dist/index.min.js"></script>
<div id="spreadsheet"></div>
<script>
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('YzY3OGE2NDk1YWMwZTA0ZjIyN2VhODQzNjE0Y2NmYjIyMjdjODkwMDM5YmM1NzYyOTg3NzIwZjY1ZThlYzA3NTk2MWViYWRkOTY2M2M2ODgzY2I4OWNkMGYyNTI0MmUxNzNkNzJmNWU5ZTJkM2Y5NTY4Y2Q0MzEzMjlmZTUyMmQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek0xTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
// Create a new spreadsheet
jspreadsheet(document.getElementById('spreadsheet'), {
worksheets: [{
data: [
[
"Time",
"Minutes"
],
[
"9:15:30 AM",
"=MINUTE(A2)"
],
[
"2:45:15 PM",
"=MINUTE(A3)"
],
[
"11:08:45 PM",
"=MINUTE(A4)"
],
[
"6:30:00 AM",
"=MINUTE(A5)"
]
]
}]
});
</script>
</html>
import React, { useRef } from "react";
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/react";
import formula from "@jspreadsheet/formula-pro";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
// Set license
jspreadsheet.setLicense('YzY3OGE2NDk1YWMwZTA0ZjIyN2VhODQzNjE0Y2NmYjIyMjdjODkwMDM5YmM1NzYyOTg3NzIwZjY1ZThlYzA3NTk2MWViYWRkOTY2M2M2ODgzY2I4OWNkMGYyNTI0MmUxNzNkNzJmNWU5ZTJkM2Y5NTY4Y2Q0MzEzMjlmZTUyMmQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek0xTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default function App() {
// Spreadsheet array of worksheets
const spreadsheet = useRef();
// Worksheet data
const data = [
[
"Time",
"Minutes"
],
[
"9:15:30 AM",
"=MINUTE(A2)"
],
[
"2:45:15 PM",
"=MINUTE(A3)"
],
[
"11:08:45 PM",
"=MINUTE(A4)"
],
[
"6:30:00 AM",
"=MINUTE(A5)"
]
];
// Render component
return (
<Spreadsheet ref={spreadsheet}>
<Worksheet data={data} />
</Spreadsheet>
);
}
<template>
<Spreadsheet ref="spreadsheet">
<Worksheet :data="data" />
</Spreadsheet>
</template>
<script>
import { Spreadsheet, Worksheet, jspreadsheet } from "@jspreadsheet/vue";
import "jsuites/dist/jsuites.css";
import "jspreadsheet/dist/jspreadsheet.css";
import formula from "@jspreadsheet/formula-pro";
// Set license
jspreadsheet.setLicense('YzY3OGE2NDk1YWMwZTA0ZjIyN2VhODQzNjE0Y2NmYjIyMjdjODkwMDM5YmM1NzYyOTg3NzIwZjY1ZThlYzA3NTk2MWViYWRkOTY2M2M2ODgzY2I4OWNkMGYyNTI0MmUxNzNkNzJmNWU5ZTJkM2Y5NTY4Y2Q0MzEzMjlmZTUyMmQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek0xTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
export default {
components: {
Spreadsheet,
Worksheet,
},
data() {
// Worksheet data
const data = [
[
"Time",
"Minutes"
],
[
"9:15:30 AM",
"=MINUTE(A2)"
],
[
"2:45:15 PM",
"=MINUTE(A3)"
],
[
"11:08:45 PM",
"=MINUTE(A4)"
],
[
"6:30:00 AM",
"=MINUTE(A5)"
]
]
return {
data
};
}
}
</script>
import { Component, ViewChild, ElementRef } from "@angular/core";
import jspreadsheet from "jspreadsheet";
import * as formula from "@jspreadsheet/formula-pro";
// Set your JSS license key (The following key only works for one day)
jspreadsheet.setLicense('YzY3OGE2NDk1YWMwZTA0ZjIyN2VhODQzNjE0Y2NmYjIyMjdjODkwMDM5YmM1NzYyOTg3NzIwZjY1ZThlYzA3NTk2MWViYWRkOTY2M2M2ODgzY2I4OWNkMGYyNTI0MmUxNzNkNzJmNWU5ZTJkM2Y5NTY4Y2Q0MzEzMjlmZTUyMmQsZXlKamJHbGxiblJKWkNJNklpSXNJbTVoYldVaU9pSktjM0J5WldGa2MyaGxaWFFpTENKa1lYUmxJam94TnpVM01ETXhNek0xTENKa2IyMWhhVzRpT2xzaWFuTndjbVZoWkhOb1pXVjBMbU52YlNJc0ltTnZaR1Z6WVc1a1ltOTRMbWx2SWl3aWFuTm9aV3hzTG01bGRDSXNJbU56WWk1aGNIQWlMQ0p6ZEdGamEySnNhWFI2TG1sdklpd2lkMlZpWTI5dWRHRnBibVZ5TG1sdklpd2lkMlZpSWl3aWJHOWpZV3hvYjNOMElsMHNJbkJzWVc0aU9pSXpOQ0lzSW5OamIzQmxJanBiSW5ZM0lpd2lkamdpTENKMk9TSXNJbll4TUNJc0luWXhNU0lzSW1Ob1lYSjBjeUlzSW1admNtMXpJaXdpWm05eWJYVnNZU0lzSW5CaGNuTmxjaUlzSW5KbGJtUmxjaUlzSW1OdmJXMWxiblJ6SWl3aWFXMXdiM0owWlhJaUxDSmlZWElpTENKMllXeHBaR0YwYVc5dWN5SXNJbk5sWVhKamFDSXNJbkJ5YVc1MElpd2ljMmhsWlhSeklpd2lZMnhwWlc1MElpd2ljMlZ5ZG1WeUlpd2ljMmhoY0dWeklpd2labTl5YldGMElsMHNJbVJsYlc4aU9uUnlkV1Y5');
// Set the extensions
jspreadsheet.setExtensions({ formula });
@Component({
standalone: true,
selector: "app-root",
template: `<div #spreadsheet></div>`
})
export class AppComponent {
@ViewChild("spreadsheet") spreadsheet: ElementRef;
// Worksheets
worksheets: jspreadsheet.worksheetInstance[];
// Create a new data grid
ngAfterViewInit() {
// Create spreadsheet
this.worksheets = jspreadsheet(this.spreadsheet.nativeElement, {
worksheets: [{
data: [
[
"Time",
"Minutes"
],
[
"9:15:30 AM",
"=MINUTE(A2)"
],
[
"2:45:15 PM",
"=MINUTE(A3)"
],
[
"11:08:45 PM",
"=MINUTE(A4)"
],
[
"6:30:00 AM",
"=MINUTE(A5)"
]
]
}]
});
}
}