How To Convert Seconds To Minutes In Excel: 10 Steps - WikiHow Tech

Skip to Content

Subscribe
• EXPLORERandom Article

• Home
• Random

Terms of Use

2readers helped!

This helped me How to Convert Seconds to Minutes in Excel Explore this Article Steps Steps Other Sections Related Articles References Article Summary Written by Nicole Levine, MFA

Last Updated: July 12, 2024 Tested

X

This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. The wikiHow Tech Team also followed the article's instructions and verified that they work. This article has been viewed 3,407 times.

This wikiHow teaches you how to convert seconds to minutes in Microsoft Excel. After running a formula that tells Excel to interpret the seconds as time, you can display the results in a proper time format.

Steps

1. 1 Open your spreadsheet in Microsoft Excel. You'll usually find Excel in the All Apps area of the Start menu (Windows) or in the Applications folder (macOS).
2. 2 Click an empty cell and type =. Use a cell in an empty column. This creates a new formula. Advertisement
3. 3 Click the cell that contains the seconds you want to convert. The cell's location (e.g., B4) now appears in the formula.
4. 4 Type /86400. This tells Excel to divide the number of seconds by 86400.
   • 86400 is 24 (hours in a day) X 60 (minutes in an hour) X 60 (seconds in a minute).[1]
   • The formula should now look like this (using ″B4″ as the cell containing the number of seconds): =B4/86400.
   • To simply convert a value in seconds to a value in minutes, you can divide by 60 instead. To format the value as a time, though, use the 86,400 value and continue on to the next step.
5. 5 Press ↵ Enter or ⏎ Return. The results of the formula will appear. The format may still appear funny, but you're about to fix that.
6. 6 Right-click the letter above the column in which you entered the formula. For example, if you typed the formula in C4, right-click the C above the column. This selects the column and opens a menu.
7. 7 Click Number Format. If you don't see this option, click Format then ""Cells"" or ""Format cells"", and then click the Number tab.[2]
8. 8 Click Time. It's under the ″Category″ header on the left side of the panel. A list of time formats will appear.
9. 9 Select a time format. Since you're working with seconds, choose either 30.55.2 (popular in most countries) or 37:30:55 (popular in the US), as these formats display hours, minutes, and seconds.
10. 10 Click OK. The seconds you converted to minutes now appear in the correct format. Advertisement

Expert Q&A

Search Add New Question Ask a Question 200 characters left Include your email address to get a message when this question is answered. Submit Advertisement

You Might Also Like

How toLog in to WeChat How to Download and Save Facebook Videos Without Any Software on Your Computer, Phone, or Tablet How toCopy a QR Code on Android How toFind an Office Product Key Change Your Cameos Selfie in Snapchat: 2 Simple Methods The Beginner's Guide on How to Use Clubhouse (& Host Your Own Room) How toAdd an Email Account to Your iPhone How toInstall Progressive Web Apps How toSelect Multiple Files on Windows 11 How toContact WhatsApp How toMake a Background Transparent in Paint How toUse Microsoft Whiteboard How toCheck Power Consumption of a PC How toCall Someone on a Computer Advertisement

References

1. ↑ https://exceljet.net/formula/convert-decimal-seconds-to-excel-time
2. ↑ https://www.myonlinetraininghub.com/excel-date-and-time-formatting

About this article

Written by: Nicole Levine, MFA wikiHow Technology Writer This article was co-authored by wikiHow staff writer, Nicole Levine, MFA. Nicole Levine is a Technology Writer and Editor for wikiHow. She has more than 20 years of experience creating technical documentation and leading support teams at major web hosting and software companies. Nicole also holds an MFA in Creative Writing from Portland State University and teaches composition, fiction-writing, and zine-making at various institutions. This article has been viewed 3,407 times. How helpful is this? Co-authors: 6 Updated: July 12, 2024 Views: 3,407 Article SummaryX

1. Open an Excel spreadsheet. 2. Select the cells you want to convert. 3. Right-click on the selected cells, and click Format Cells. 4. Select Custom under Category. 5. Select "mm:ss" under Type. Did this summary help you?YesNo

• Print

Thanks to all authors for creating a page that has been read 3,407 times.

Is this article up to date?

Yes No Advertisement Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Written by: Nicole Levine, MFA wikiHow Technology Writer Click a star to vote Co-authors: 6 Updated: July 12, 2024 Views: 3,407

You Might Also Like

How toLog in to WeChatHow to Download and Save Facebook Videos Without Any Software on Your Computer, Phone, or TabletHow toCopy a QR Code on AndroidHow toFind an Office Product Key wikiHow Newsletter You're all set! Helpful how-tos delivered toyour inbox every week! Sign me up! By signing up you are agreeing to receive emails according to our privacy policy.

• Home
• About wikiHow
• Experts
• Contact Us
• Terms of Use
• Privacy Policy
• Do Not Sell or Share My Info
• Not Selling Info

Follow Us

×

wikiHow Tech Help:

Tech troubles got you down? We've got the tips you need

Subscribe You're all set! --341