MINUTE

Returns the minutes of a given time.

Syntax:

MINUTE(time)

returns the minutes of time as a number, 0 - 59. time may be text or a date-time serial number.

Example:

MINUTE("2021-01-06 21:30:15")

returns 30.

MINUTE(A1)

where cell A1 contains the time 9:25:10 as a date-time serial number, returns 25.

Explanation of Each Column and Its Results:

1. Scheduled Start Time:
2. • What is it? This column stores the date and time when each meeting was officially planned to begin. These are full datetime values, meaning they include the year, month, day, hour, minute, and second.
   • Results:
   • • M001: Scheduled for 9:00 AM on August 4, 2025.
     • M002: Scheduled for 10:30 AM on August 4, 2025.
     • M003: Scheduled for 2:15 PM on August 4, 2025.
     • M004: Scheduled for 4:00 PM on August 4, 2025.
2. Actual Start Time:
3. • What is it? This column records the precise date and time when each meeting actually commenced. Like the scheduled time, these are also full datetime values.
   • Results:
   • • M001: Started at 9:05:00 AM on August 4, 2025.
     • M002: Started at 10:30:00 AM on August 4, 2025.
     • M003: Started at 2:20:00 PM on August 4, 2025.
     • M004: Started at 3:50:00 PM on August 4, 2025.
3. Scheduled Minute:
   What is it? This column extracts and displays only the minute component (a number from 0 to 59) from the "Scheduled Start Time" using the MINUTE() function. It does not consider the hour or date, only the minute part of the specified time. This is useful for analyzing trends related to the minute of the hour, rather than the overall time difference.
   Results:
   M001: MINUTE(09:00:00) results in 0.
   M002: MINUTE(10:30:00) results in 30.
   M003: MINUTE(14:15:00) results in 15.
   M004: MINUTE(16:00:00) results in 0.
4. Actual Minute:
   What is it? Similar to "Scheduled Minute," this column uses the MINUTE() function to extract only the minute component (0-59) from the "Actual Start Time." This provides insight into the exact minute of the hour when the meeting actually began, again, without regard for the hour or date.
   Results:
   M001: MINUTE(09:05:00) results in 5.
   M002: MINUTE(10:30:00) results in 30.
   M003: MINUTE(14:20:00) results in 20.
   M004: MINUTE(15:50:00) results in 50.
5. Minute Difference ((Actual - Scheduled) * 1440):
6. • What is it? This is a calculated column that quantifies the difference in minutes between the Actual Start Time and the Scheduled Start Time. The calculation (Actual - Scheduled) first yields a fractional number representing the difference in "days" (since spreadsheets store dates and times as serial numbers where 1 day = 1 unit). This "days" difference is then multiplied by 1440 (the number of minutes in a day, i.e., 24 hours * 60 minutes/hour) to convert it into the total minute difference.
   • • A positive value indicates the meeting started late.
     • A negative value indicates the meeting started early.
     • A zero value indicates the meeting started exactly on time.
   • Results:
   • • M001: (09:05:00 - 09:00:00) results in 5. The meeting started 5 minutes late.
     • M002: (10:30:00 - 10:30:00) results in 0. The meeting started exactly on time.
     • M003: (14:20:00 - 14:15:00) results in 5. The meeting started 5 minutes late.
     • M004: (15:50:00 - 16:00:00) results in -10. The meeting started 10 minutes early.
6. Delay Status:
7. • What is it? This is a categorical column derived from the Minute Difference using an IF function. It classifies the meeting's punctuality into one of three statuses: "Delayed," "Early," or "On Time." The conditions typically include a small tolerance (e.g., +/- 0.5 minutes or 30 seconds) to account for minor variations and avoid classifying a meeting as "Delayed" or "Early" for just a few seconds' difference. The formula used is typically IF(Minute_Difference > 0.5, "Delayed", IF(Minute_Difference < -0.5, "Early", "On Time")).
   • Results:
   • • M001: Minute Difference is 5. Since 5 is greater than 0.5, the status is "Delayed".
     • M002: Minute Difference is 0. Since 0 is neither greater than 0.5 nor less than -0.5, the status is "On Time".
     • M003: Minute Difference is 5. Since 5. is greater than 0.5, the status is "Delayed".
     • M004: Minute Difference is -10. Since -10 is less than -0.5, the status is "Early".