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.

How do you have the time formatted now? Please post an example.

Didn't we do this already?

MIKE

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

If it is formatted as: 127min Then this should work:

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

MIKE

Ask Your Question

Weekly Poll