• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

another excel question

C

cam

Guest
#1
is it possible to convert a raw amount of minutes into h:m.. example


you have a result of 116 minutes from another formula, but you want to convert it to 1h56m on the page.. outside of manually typing it (yech!) what are my options?

thanks!
 

Khayman

I'm sorry Hal...
Political User
#3
this should work

=INT(A1/60)&" hours "&MOD(A1,60)& " minutes"

Change A1 to whatever cell the minutes are in
 

Members online

No members online now.

Latest posts

Latest profile posts

Hello, is there anybody in there? Just nod if you can hear me ...
Xie
What a long strange trip it's been. =)

Forum statistics

Threads
61,961
Messages
673,239
Members
89,013
Latest member
Pdawgintown