MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Convert Minutes To Hour:Minutes:Seconds?

Is it possible to convert minutes to hour:minutes:seconds?

Example:
Cell A1 = 125 Minutes
Cell B1 = formula to convert A1 to 2h:5m:0s
—–
Jess

Comments: 2 Responses to “How Do I Convert Minutes To Hour:Minutes:Seconds?”

    3 weeks ago

    You don’t even need to use a formula to do that. You aren’t changing the value of the cell, just displaying it in a different format.

    Select the cell, choose the Format sidebar on the right, then the Cell sidebar under that. Then set the Data Format to Duration. Then set it to Custom Units and select hr, min and sec.

    This gives you a time like:
    2h 5m 0s

    Hopefully that is what you need. Doing something like 2:05:00 will be more difficult as unfortunately you can’t create custom duration formats. But it is possible with a long formula to break out the hours, minutes and seconds and compile a text string from it.

    Jess
    3 weeks ago

    That’s perfect. Thank you for your help.

Leave a New Comment Related to "How Do I Convert Minutes To Hour:Minutes:Seconds?"

:
:
:
0/500 (500 character limit -- please state your comment succinctly and do not try to get around this limit by posting two comments)