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
