You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Convert minutes to hours and minutes

Hi Everyone,


I wish to convert minutes to hours and minutes in numbers.


If I where to input in a cell 488 I would like to see in another cell 08:08, is this feasable?


If this where possible it would really make my life so much easier.


many thanks,


Jos

Posted on Aug 19, 2020 5:06 AM

Reply
Question marked as Top-ranking reply

Posted on Aug 19, 2020 5:25 PM

Quoting from your first post: "If I where to input in a cell 488 I would like to see in another cell 08:08, is this feasable?"


If you input in cell B2 488 you will see in cell C2 08:08. It is feasible and the formula for cell C2 is =DURATION(,,,B2). Some formatting of cell C2 is required to display the result in the exact format you are requesting.


If you would, instead, like to type 488 into a cell and have it reformat into 08:08 in the same cell, first use the formatting sidebar on the right to format the cell as a duration with the units hours and minutes and displayed as 00:00. When entering the 488, put a "m" on the end so it knows it is minutes. 488m

5 replies
Question marked as Top-ranking reply

Aug 19, 2020 5:25 PM in response to joscelyn160

Quoting from your first post: "If I where to input in a cell 488 I would like to see in another cell 08:08, is this feasable?"


If you input in cell B2 488 you will see in cell C2 08:08. It is feasible and the formula for cell C2 is =DURATION(,,,B2). Some formatting of cell C2 is required to display the result in the exact format you are requesting.


If you would, instead, like to type 488 into a cell and have it reformat into 08:08 in the same cell, first use the formatting sidebar on the right to format the cell as a duration with the units hours and minutes and displayed as 00:00. When entering the 488, put a "m" on the end so it knows it is minutes. 488m

Convert minutes to hours and minutes

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.