Forum Discussion
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
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
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] simple and effective. Excellent!
