Thursday, April 28, 2022

MINUTE function [MS]

Returns the minutes of a time value. The minute is given as an integer, ranging from 0 to 59.

Syntax

MINUTE(serial_number)

Serial_number     is the time that contains the minute you want to find. Times may be entered as text strings within quotation marks (for example, "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM), or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).

Remark

Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5, since it is half of a day).

Example

Formula

Description (Result)

=MINUTE("4:48:00 PM")

Minutes of the time (48)

No comments:

Post a Comment

Search This Blog

Restore a previous version of an item or file in SharePoint [MS]

SharePoint Documents and Libraries Check out & s...