4 minutes
18 minutes
2 minutes
3 minutes
6 minutes
1 minute
1 minute
2 minutes
1 hour 9 minutes
1 minute
22 minutes
1 minute
15 minutes
31 minutes
3 minutes
25 minutes
10 minutes
5 minutes
30 minutes

Nope that did not work. The examples above is the data I am pulling from
word. When I cpoy it into the cell and try to format it nothing happens.
Any other ideas?

"Marcelo" wrote:

http://www.asap-utilities.com/?cf89A... Wm6I2bdXkgcx

check the asap utilities site, they have an addin that could solve your
problems
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jamie" escreveu:

I have data that is in a word document and it is written "37 Minutes". When
i copy that data into a cell in excel I want it to just show "37". I have
tried different formatiing option but to no avail. I also have a field
written out "1 Hour and 33 minutes" and want to convert that as well.

Any ideas?