In the General Area, enter mm:ss or click it in the list.īelow is the Format Cells dialog box with the minutes and seconds custom format:.Click Custom in the category on the left.Press Ctrl + 1 or right-click and select Format Cells.Select the cells, columns or rows to which you want to apply a custom number format.To apply custom number formatting for minutes and seconds, enter or select a time format using the Format Cells dialog box: Recommended article: 10 Great Excel Pivot Table Shortcutsĭo you want to learn more about Microsoft Excel? Check out our virtual classroom or live classroom Excel courses > Applying a custom number format for minutes and seconds To convert seconds to minutes and seconds, you can divide the seconds by the total number of seconds in a day and then apply the time custom number format to display as minutes and seconds. However, 80 seconds is actually 1:20 or 1 minute and 20 seconds. Since there are 60 seconds in a minute, you may try to divide it by 60, but the result will be a minute and a fraction, not minutes and seconds (in this case, 1.34). Let's say you have entered 80 in a cell (representing 80 seconds) and you want to convert it to the equivalent of minutes and seconds. Because time is calculated in Excel as a fraction of a day, you can convert fractions to appropriate time increments by combining calculations and custom number formatting. Use Calculations and Formatting to Convert Seconds to Minutes and Seconds in Microsoft Excelīy Avantix Learning Team | Updated April 6, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)Īlthough you can convert seconds to minutes and seconds in Excel, it can be a bit tricky to convert and display times in combined units (hours, minutes and seconds).
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |