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”)

Formula

There are 3 parts to the formula

  1. Reference, the time in minutes
  2. ‘From’ unit
  3. ‘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.

Select from Drop-down

Similarly, convert Grams to Kgs

 

Keep Excel-ing!