Excel Min Sec Format: Display Minutes and Seconds

How-to basics · Updated November 18, 2026

To display minutes and seconds in Excel, select the cells, press Ctrl+1, choose Number > Custom, and enter [m]:ss for elapsed time that may exceed 59 minutes. Use mm:ss when the display should represent minutes and seconds within each hour; the format changes how a value looks, not the value Excel stores.

What the Excel min sec format means

Excel stores times as fractions of a day: 1 is 24 hours, 0.5 is 12 hours, and one minute is 1/1,440. A cell formatted to show minutes and seconds still contains that numeric time value. This is why you can change a display format without changing the duration used in calculations.

The key choice is whether the minutes should keep accumulating or roll over at each hour:

  • mm:ss displays minutes within an hour. A duration of 1 hour, 2 minutes, and 5 seconds appears as 02:05.
  • [m]:ss displays total elapsed minutes. The same duration appears as 62:05.
  • [h]:mm:ss displays total elapsed hours, followed by minutes and seconds. The duration appears as 1:02:05.

For ordinary short timings—such as a lap or a cooking interval—mm:ss may be all you need. For work logs, accumulated audio time, or a sum that can pass an hour, [m]:ss prevents the displayed minutes from starting over at zero after 59.

Apply a custom minutes-and-seconds format

In Excel for Microsoft 365 on Windows, select the cells, press Ctrl+1 to open Format Cells, choose the Number tab, and select Custom. Enter the desired code in the Type box, then select OK. For a total-minutes display, enter [m]:ss; for a minutes-within-the-hour display, enter mm:ss.

On a Mac, select the cells and press Command+1 to open the Format Cells dialog, then choose Number > Custom and enter the format. The dialog labels can vary slightly by Excel release. In Excel for the web, look under Home > Number Format for the available number-format options; if you cannot create or edit the custom code there, open the workbook in the desktop app and apply it there.

Custom formatting is useful because it can show leading zeros. For example, m:ss may display 2 minutes and 5 seconds as 2:05, while mm:ss displays 02:05. A leading zero improves consistency in a column, especially when values are compared visually or exported for reports.

Enter minutes and seconds without changing the meaning

Formatting cannot correct an incorrectly entered time. Excel interprets a two-part entry such as 2:35 as 2 hours and 35 minutes, not 2 minutes and 35 seconds. If you then apply [m]:ss, Excel displays that value as 155:00, because 2 hours and 35 minutes equals 155 minutes.

To enter 2 minutes and 35 seconds as a time value, type 0:02:35. This spells out hours, minutes, and seconds, with zero hours. Apply [m]:ss or mm:ss to display it as 2:35 or 02:35, respectively. For a longer duration, type all three parts: 1:02:35 means 1 hour, 2 minutes, and 35 seconds.

If a source column contains seconds as plain numbers rather than Excel time values, convert those numbers before applying a time format. With a number of seconds in A2, enter =A2/86400 in B2; 86,400 is the number of seconds in a day, so an A2 value of 155 returns an Excel time value of 0.0017939815… days, equivalent to 2 minutes and 35 seconds. Format B2 as [m]:ss to display 2:35. Fill the formula down for the other rows.

Choose between total minutes and clock-style minutes

The square brackets in [m] tell Excel to show elapsed minutes rather than the minute component of a clock time. Without brackets, the minute field repeats when the hour changes. That distinction matters most when a value is longer than an hour or is the result of adding several shorter values.

For example, suppose B2 contains 1:20:00 and B3 contains 0:55:00, each entered as hours, minutes, and seconds. With those two durations in B2:B3, =SUM(B2:B3) returns a total of 2 hours and 15 minutes. Format the result as [m]:ss to show 135:00, or as [h]:mm:ss to show 2:15:00. A format of mm:ss shows 15:00, which hides the two-hour portion.

Use the format that communicates the quantity your reader needs. If a value means “minutes elapsed,” a display such as 135:00 is direct. If it means a conventional duration with hours, minutes, and seconds, 2:15:00 is generally easier to read. Neither format changes the sum.

Display seconds, tenths, or hundredths

For measurements that need fractional seconds, add decimal places after the seconds field. The custom code [m]:ss.0 displays tenths of a second, and [m]:ss.00 displays hundredths. For example, a duration close to 2 minutes, 35 seconds, and 4 tenths appears as 2:35.4 with the first code, or 2:35.40 with the second.

The extra digits are a display choice, not a way to create precision that is absent from the stored value. Excel rounds the displayed result to the number of decimal places specified, while keeping the underlying value. If the measurement itself was rounded or recorded only to whole seconds, showing two decimal places can suggest more precision than the data supports.

For a display that includes hours and fractional seconds, use a form such as [h]:mm:ss.00. The minute and second fields remain two digits, while the bracketed hour count continues past 24 hours instead of wrapping like a clock.

Common display and calculation problems

  • The result shows 00:00: The cell may contain text rather than a numeric time, or the duration may be too small for the displayed precision. Check whether the value is left-aligned or preceded by an apostrophe, and confirm that the cell contains a time value rather than text.
  • Minutes reset after 59: Change mm:ss to [m]:ss if you want total elapsed minutes. The reset is expected behavior for the unbracketed minute field.
  • A value is unexpectedly much larger: Check how it was typed. An entry of 2:35 is two hours and 35 minutes in Excel’s usual time-entry convention. For two minutes and 35 seconds, enter 0:02:35.
  • Excel shows hash marks: A column that is too narrow can show #### instead of a formatted value; widen it first. Negative time values can also be problematic in Excel’s default 1900 date system. Avoid switching date systems merely to hide the marks, because that setting can affect date interpretation throughout a workbook.
  • Adding durations gives an unexpected display: The arithmetic may be correct even when the format hides hours or wraps minutes. Check the underlying total using a format such as [h]:mm:ss or [m]:ss.

A useful diagnostic is to temporarily apply a more explicit format such as [h]:mm:ss. If that reveals hours you did not expect, revisit the input and decide whether the source values represent hours, minutes, seconds, or plain numbers. Changing the custom format alone cannot convert between those units.

Use a format consistently across a workbook

Choose one convention for each kind of data and use it consistently. A worksheet that mixes mm:ss and [m]:ss can make two equal-looking values mean different things once durations exceed an hour. Add a clear column heading, such as “Elapsed time (min:sec)” or “Duration (h:mm:ss),” so readers know what the numbers represent.

When copying cells, the number format may travel with the value, depending on the paste option. If a pasted duration suddenly displays differently, select the destination and reapply the intended custom format. You can also use Format Painter to copy formatting, but check that the destination cells contain compatible values; formatting a plain number as a time does not automatically convert its units.

For a printed report or shared file, consider whether all durations can exceed an hour. If they can, prefer [m]:ss or [h]:mm:ss and verify a long example after summing. This prevents a total such as 75 minutes from being mistaken for 15 minutes.

Frequently Asked Questions

What is the Excel format for minutes and seconds?
Use mm:ss for minutes and seconds that repeat after each hour. Use [m]:ss when the minutes should show the total elapsed minutes, including values above 59.

How do I show more than 60 minutes in Excel?
Apply the custom number format [m]:ss. For example, 1 hour and 15 minutes displays as 75:00. If you prefer an hour field, use [h]:mm:ss to show 1:15:00.

How do I enter 2 minutes and 30 seconds?
Type 0:02:30 so Excel reads the parts as hours, minutes, and seconds. Then apply mm:ss or [m]:ss. Typing 2:30 alone normally means 2 hours and 30 minutes.

Can I add minutes-and-seconds values in Excel?
Yes, if the cells contain numeric time values rather than text. Use a normal addition or SUM formula, then format the result with [m]:ss or [h]:mm:ss so the total does not appear to wrap at an hour.

Why does Excel show 00:00 after I enter seconds?
If you entered a whole number such as 155, Excel treats it as 155 days, not 155 seconds. Convert seconds to a time fraction by dividing by 86,400, then apply a minutes-and-seconds format.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.