Google Sheets: Add Minutes to a Time

To add minutes to a time in Google Sheets, add the minutes divided by 1,440 to the time value: for example, if A1 contains 9:15 AM, use =A1+30/1440 to get 9:45 AM. Format the result as a time; if the calculation crosses midnight, use a date-time format or account for the day change.

Enter the Time and Minutes

Sheets stores times as fractions of a day: midnight is 0, noon is 0.5, and a complete day is 1. This is why adding a number such as 30 directly to a time is not the way to add 30 minutes. Convert minutes to a fraction of a day by dividing by 1,440, the number of minutes in 24 hours.

For a simple calculation, enter a time in A1 and use a formula such as:

• =A1+15/1440 to add 15 minutes
• =A1+45/1440 to add 45 minutes
• =A1+B1/1440 if A1 contains the starting time and B1 contains the number of minutes to add

Enter a time Sheets recognizes, such as 9:15 AM, and a numeric minute value such as 30. You can also enter times in 24-hour style, such as 14:20, depending on the spreadsheet’s locale and formatting.

Format the Result as a Time

A correct formula can appear to produce an unexpected number if the result cell is formatted as a plain number. Select the result cell, open Format > Number, and choose a time format. Available display options can vary with locale and spreadsheet settings.

For example, if A1 is 9:15 AM and the formula is =A1+30/1440, the result should display as 9:45 AM. The underlying value is still a fraction of a day; formatting changes how that value is shown, not the calculation itself.

If the minutes to add are in B1, the formula =A1+B1/1440 makes the calculation easy to reuse down a column. Make sure B1 is a number of minutes, not a duration that has already been entered as a time value.

Add Minutes with TIME

Another clear option is the TIME function, which constructs a time from hours, minutes, and seconds. To add a number of minutes stored in B1 to a time in A1, write:

=A1+TIME(0,B1,0)

For a fixed amount, use a formula such as =A1+TIME(0,30,0). This can be easier to read than dividing by 1,440, especially for people unfamiliar with Sheets’ time serial values. For a duration that includes hours as well as minutes, use =A1+TIME(hours,minutes,0), replacing the words with cell references or numeric values.

Both approaches add a duration to the starting time. TIME normalizes values that exceed the usual clock ranges, so adding 90 minutes is valid; the result reflects an hour and a half of elapsed time.

Handle Midnight and Elapsed Durations

Adding minutes can move the result into the next calendar day. For example, adding 20 minutes to 11:50 PM gives 12:10 AM on the following day. A cell formatted to show only the time displays 12:10 AM but hides which date it belongs to. If the date matters, include a date in the starting value and format the result to show both date and time.

For elapsed durations longer than 24 hours, a regular clock format can wrap around and show only the time of day. Use a duration format that displays total hours, such as [h]:mm, when you need to see accumulated hours rather than a clock reading. The square brackets allow the hour count to continue past 24.

To show a time-only result that wraps at midnight, you can use =MOD(A1+B1/1440,1). This deliberately discards the date portion and keeps only the fraction representing the time of day. Do not use this version if you need to preserve the date change.

Common Formula Problems

• The result is a decimal: Change the cell’s number format to Time. The formula may be correct even when the display is not.
• The result is far too large: Check that you divided minutes by 1,440, or used TIME(0,minutes,0). Adding 30 directly adds 30 days.
• The result does not change: Confirm that the input is recognized as a time rather than text. Re-enter it in a familiar time format and check for leading apostrophes or other text-only formatting.
• The answer appears to go backward: The calculation may have passed midnight while the cell shows only the time. Include the date, or use a duration format where appropriate.
• A formula displays as text: Check whether the cell is formatted as plain text, and make sure the formula begins with an equals sign. Reformat the cell and enter the formula again if needed.

Spreadsheet locale settings can affect how times and formulas are interpreted, including separators and accepted time-entry conventions. If a formula is rejected, check the spreadsheet’s locale and use the separator conventions it expects.

When Each Method Is Useful

Use division by 1,440 for a compact formula or when minutes are stored in a cell as a plain number. Use TIME when you want the formula to express hours and minutes explicitly. Both are suitable for schedules, shift planning, appointment lists, and other calculations that add a known duration to a start time.

For a list of appointments, enter the starting time in one column and the minute increment in another, then use =A2+B2/1440 in the result column. Copy the formula down to calculate each row. Keep the input columns consistent: if one row contains minutes and another contains a time-formatted duration, the same formula may not mean the same thing for both.

Remember that adding minutes calculates elapsed time, not business hours. It does not automatically skip weekends, lunch breaks, holidays, or closed periods. Those rules require additional logic and suitable calendar data.

Frequently Asked Questions

What formula adds 10 minutes to a time in Google Sheets?
Use =A1+10/1440 when A1 contains the starting time. Format the formula cell as a time to display the answer as a clock time.

Can I add minutes stored in another cell?
Yes. If A1 contains a time and B1 contains a number of minutes, use =A1+B1/1440. The value in B1 should be a plain number of minutes.

Why does adding 30 show a different date or a large number?
Sheets represents 30 as 30 whole days when it is added directly to a time. Divide the number of minutes by 1,440, or use TIME(0,30,0).

How do I add minutes without showing the next day?
Use =MOD(A1+B1/1440,1) to keep only the time-of-day portion. This hides the date rollover, so use it only when the date is not needed.

How can I show total hours instead of a clock time?
Format the result as a duration, for example with the custom format [h]:mm. The bracketed hour format can display totals beyond 24 hours.

Related

• Measuring AI Cost Savings Without Overlooking Hidden Costs
• Control Resonant: Why Piracy Forums Push Players to Buy It
• Apple Maps Not Showing Map? Fixes That Work