Forum Discussion

Adam08780's avatar
Adam08780
Copper Contributor
Feb 01, 2024

Converting Custom Text Cell to Minutes

How can I convert this to minutes only?

HH:MM:SSShould be
12:29:21749
8:41:15521
7:02:01422

Please advise

  • If you go into cell format - number format - custom format - and enter [m] it will DISPLAY in minutes.
    If you want to convert to that value then
    =A2*24*60
    and you can then decide if you want to visually remove the fraction of a min (again go to cell properties and set # of digits to display to 0) or wrap it with ROUND or ROUNDDOWN or FLOOR or CEILING depending on how you want it to round or truncate
  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    If you go into cell format - number format - custom format - and enter [m] it will DISPLAY in minutes.
    If you want to convert to that value then
    =A2*24*60
    and you can then decide if you want to visually remove the fraction of a min (again go to cell properties and set # of digits to display to 0) or wrap it with ROUND or ROUNDDOWN or FLOOR or CEILING depending on how you want it to round or truncate

Resources