Forum Discussion
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?
For Hours: =INT("High"/60)
For Minutes: ="High"-"Hours"*60
....where you replace "High" and "Hours" by the relevant cell references.
5 Replies
If your minutes are in A2, try this...
Hours:
=INT(A2/60)
Minutes:
=MOD(A2,60)
You're welcome Sameer_Kuppanath_Sultan!
For Hours: =INT("High"/60)
For Minutes: ="High"-"Hours"*60
....where you replace "High" and "Hours" by the relevant cell references.
