Solved Converting minutes to a number only in excell

August 22, 2013 at 15:29:41
Specs: Windows 7
I am trying to convert a time given in minutes to a number only in an excel cell ie 127min to just 127 so that I can apply a formula.

See More: Converting minutes to a number only in excell

Report •


#1
August 22, 2013 at 15:57:33
How do you have the time formatted now?

Please post an example.

Didn't we do this already?

MIKE

http://www.skeptic.com/


Report •

#2
August 23, 2013 at 04:50:36
It is currently formatted as 127min and I am trying to have it converted to number only (in minutes) ie 127. You helped me with changing an Hour Minute format to a decimal format and I tried to adapt that information, but I apparently did not understand the process as I thought I did as I was unable to make it work for this application.

message edited by mathgirl


Report •

#3
August 23, 2013 at 05:46:14
✔ Best Answer
If it is formatted as: 127min

Then this should work:

=LEFT(A1,FIND("m",A1,1)-1)

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question