Forum Discussion

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

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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor

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 guy.
    I learned a lot from him!

     

    Regards

Resources