Forum Discussion
Adam08780
Feb 01, 2024Copper Contributor
Converting Custom Text Cell to Minutes
How can I convert this to minutes only?
HH:MM:SS | Should be |
12:29:21 | 749 |
8:41:15 | 521 |
7:02:01 | 422 |
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
- NikolinoDEGold Contributor
- m_tarlerBronze ContributorIf 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- Adam08780Copper Contributor[m] simple and effective. Excellent!