Forum Discussion

Sameer_Kuppanath_Sultan's avatar
Sameer_Kuppanath_Sultan
Brass Contributor
Dec 13, 2019
Solved

Convert Mins to Hrs and Mins in two column

Howto convert a number of mins to hours and mins in 2 columns as shown in the below image?  
excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 13, 2019

    Sameer_Kuppanath_Sultan 

    For Hours: =INT("High"/60)

    For Minutes: ="High"-"Hours"*60

     

    ....where you replace "High" and "Hours" by the relevant cell references.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 13, 2019

Sameer_Kuppanath_Sultan 

For Hours: =INT("High"/60)

For Minutes: ="High"-"Hours"*60

 

....where you replace "High" and "Hours" by the relevant cell references.

Resources