Convert Second to Minutes in Excel (3 Easy Ways)

In this video, I will show you three easy ways to convert seconds to minutes in Excel.
While you can convert a value in seconds to minutes by dividing it by 60, this is not how it works in Excel. And that's because Excel stores date and time values in a different way.
In this video, I will show you the right way to convert seconds to minutes in Excel (using simple formulas).
00:00 Introduction
00:24 Using Simple Division with Custom Number Formatting
03:59 Using the TEXT function
05:44 Using INT and MOD function
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: th-cam.com/users/trumpexc...
#Excel #ExcelTips #ExcelTutorial

[@Joseph-xt2qg]

Best explanatory video I have seen on this topic. I have been using Excel in a professional setting for more than 10 years and have never been able to grasp time and date

[@msmythkasis3666]

Thank you! I stopped a project for months just because of this. But today I'm trying to retake that project and I've been working ontbis the whole day. Until I found your video. Thank you so much!

[@neilgore]

Super .. only 236 "likes" till 12.05.2023 .. needs thousands .. such simple explanation.. Thank you

[@IvanCortinas_ES]

Excellent tutorial Sumit!!! Thank you for the three methods.

[@wayneedmondson1065]

Great Sumit! Thanks for the tips. Thumbs up!!

[@npc2856]

Excellent explanation! I love how you usually give options for different ways of doing the same thing. Very useful!

[@trumpexcel]

Thank you for the kind words... I am glad you found the video helpful 🙂

[@miall69]

Amazing stuff. Thank you for sharing.

[@iamsadist]

Thanks Buddy for nice video

[@wmfield152]

Thanks for this valuable instruction, Sumit. I aLways appreciate your videos.

[@kpiskpis739]

Excellent !! Hope to see more useful videos.

[@vinayakjoshi1421]

My heartiest thanks sir

[@mohanvaze1]

Very interesting and useful. Thank you 😊

[@ricardomantovaniassis]

Sumit, thank you for your video.

[@damirpavlic3783]

Thank you.

[@shashitiwari3440]

Thanks

[@ARIFSAIFIFARHAN]

I enjoyed the 3rd method the most

[@user-kd7nn9ht8u]

thanks

[@vikaskoli824]

Easy way 👍

[@Yannicksts]

Thanks a lot... super well explained

[@trumpexcel]

Glad you found the video helpful :)

[@rajeevgosavi4514]

Sumitji , you have explained the concept very nicely. Thanks. Can we solve this in power query so that it may not get converted into text.

[@endthefed9937]

Another great video!

[@trumpexcel]

Glad you found the video useful 🙂

[@amritasyaputrah6693]

Need to ask u something in excel but difficult to explain over msg.

[@user-ni1br7zf4j]

Hello,
In case in column
8 min 40 sec
12 min 3 sec
46 sec
13 min 1 sec
this type of data store into one column then how I calculate total minutes means every row total minutes.

[@redhaakhund1271]

👍👍👍👍👍

[@iamsadist]

Can anyone tell me
How can I copy paste in filter???

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course

[@amritasyaputrah6693]

How to contact u?

[@trumpexcel]

You can send me an email at [e-mail]

[@vikaskoli824]

Fast master lookup in lakh row