SOLVED

Converting Custom Text Cell to Minutes

Copper 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

3 Replies
best response confirmed by Adam08780 (Copper Contributor)
Solution

Re: Converting Custom Text Cell to Minutes

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

Re: Converting Custom Text Cell to Minutes

=HOUR(A2) * 60 + MINUTE(A2) + SECOND(A2) / 60

as a example.

Hope this helps you.

Re: Converting Custom Text Cell to Minutes

[m] simple and effective. Excellent!
1 best response

Accepted Solutions
best response confirmed by Adam08780 (Copper Contributor)
Solution

Re: Converting Custom Text Cell to Minutes

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