This can easily be done by using the formula =CONVERT
Let’s say you have in a cell 1150 minutes written, and you want to convert it to Hours.
Cell A1 has 1150 written, we are writing the =CONVERT formula in cell B1.
=CONVERT (A1, “mn”, “hr”)
There are 3 parts to the formula
- Reference, the time in minutes
- ‘From’ unit
- ‘To’ unit
The ‘From’ and ‘To’ units need not be typed manually, there will be a drop-down atomically given by Excel, where you can select your required unit.
Similarly, convert Grams to Kgs