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.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
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
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
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
Formula =DURATION(,,,B2)
Then cell is formatted to display the duration the way you want to see it.
Hi and thank you for that.
I was after a formula to work out hours and minutes 8:08 if I where to input just minutes 488.
Sorry if I was not clear in the first message, is this possible?
Thanks
Jos
Is the problem the leftmost 0 not being there? Or did I screw up the formula (it wouldn't be the first time)?
Thank you so much, I get it now.
It has worked a treat and saved me so much time.
Many thanks
Jos
Convert minutes to hours and minutes
