Microsoft Excel - subtract one minute from hour

To subtract a minute from a time in Microsoft Excel, you can use a simple formula, as time in Excel is represented as a number where 1 day equals 1, and each part of the day (e.g. hour, minute) is a fraction of that number.

Quick solution:

xxxxxxxxxx

= A1 - TIME(0, 1, 0)

1. Suppose you have a time in cell A1 (e.g., 12:30).
2. To subtract 1 minute, use the following formula:
   Copy

   xxxxxxxxxx

    

   1

   = A1 - TIME(0, 1, 0)

   This formula subtracts 1 minute from the time in cell A1. The TIME(0, 1, 0) function represents 1 minute.

Example:

• If A1 contains 12:30, after applying the formula, the result will be 12:29.

Notes:

• If cell A1 contains both date and time (e.g. 2024-11-20 12:30), the formula will still work correctly and subtract 1 minute from the full datetime.