SOLVED

Converting Custom Text Cell to Minutes

Copper Contributor

How can I convert this to minutes only?

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

Please advise

3 Replies
best response confirmed by Adam08780 (Copper Contributor)
Solution
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

@Adam08780 

 

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

 

as a example.

 

Hope this helps you.

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

Accepted Solutions
best response confirmed by Adam08780 (Copper Contributor)
Solution
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

View solution in original post