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?

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

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

    3 years 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.

    3 years ago

    That's perfect. Thank you for your help.

Comments Closed.