Excel: How to Convert Time Duration to Seconds - Statology With these values, you can format it to show in different ways (such as showing it in hh:mm:ss format) and can also use these in calculations. After dividing by 86400, you can apply a time format of your choice, or use the result in a math operation with other . Step 3: In the second cell, enter the formula "=A1*60", where A1 is the cell containing the minutes. Prash Shirolkar
For decimals, format your result cells as numbers also using the Format Cells feature. In this tutorial, I will show you everything you need to know about converting seconds into minutes and seconds using a simple formula and some number formatting magic. And obviously, that will include time. In this way, you can convert time to seconds manually. In this case, use the CONVERT function as follows: With this formula, you can save the time and effort you'd otherwise spend manually calculating conversions in your spreadsheet. If you want to report an error, or if you want to make a suggestion, do not hesitate to send us an e-mail: W3Schools is optimized for learning and training. It is mandatory to procure user consent prior to running these cookies on your website. CONVERT function - Microsoft Support Check out our virtual classroom or live classroomExcel courses >. We use cookies on this web site to improve your experience and for visitor analytics. Syntax. Here is a step-by-step breakdown of how to have Excel convert time to seconds: If we take the example time as being 1:40:30 AM and want to figure out how many seconds that is, we can use the following approach. Read More: How to Convert Seconds to Hours Minutes Seconds in Excel. So, in this article, you will find 2 ways to convert minutes to seconds in Excel. Because each hour can be represented as 1/24, you can convert an Excel time into decimal hours by multiplying the value by 24, convert to decimal minutes by multiplying the value by 1440 (24 * 60) , and convert to seconds by multiplying by 86400 (24 * 60 * 60). In the following example, we have entered seconds in column A that we want to convert to minutes and seconds in column B: To convert seconds entered in column A to minutes and seconds in column B: Column B appears as follows with the General format applied: To format column B as minutes and seconds: Column B appears as follows with the mm:ss format applied: Here's another example.