Forum Discussion

Jerry Bodine's avatar
Jerry Bodine
Copper Contributor
Jul 14, 2018
Solved

Code Formatting

I'm developing a spreadsheet in Excel 2016 (Office 365, Version 16.0.7167.2055). I want to find out how to convert an number in a cell that represent a quantity in "seconds" that I want to convert to...
excel
office 365
  • Haytham Amairah's avatar
    Haytham Amairah
    Jul 15, 2018

    Hi Jerry,

     

    Please try this formula:

    =TEXT(TIME(0,0,ROUND(A1,0)),"[mm]:ss")

     

    Regards

Jerry Bodine's avatar
Jerry Bodine
Copper Contributor
Jul 15, 2018
Thank you very much, Haytham, that works very well. Although I have no idea how you came up with the formula. Obviously, I'm not very skilled with Excel yet.
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jul 15, 2018

Keep learning and with practice, and you will become like me!

 

If you want a strong Excel foundation for free, I would advise you to follow this https://www.youtube.com/user/ExcelIsFun.
I learned a lot from him!

 

Regards

Resources