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
