I actually think I know what is going on.

I am opening a TEXT file that contains 2 columns, and 900 rows. So when I
convert it from text to excel for some reason Column A or B are changing to
the correct format, it is getting picked up as TEXT. I can format the columns
manually and it has no affect, the only way I see to do this is to enter them
in manually all over - is there a better way?

....Mike

"Eduardo" wrote:

Hi,
use

=+RIGHT(B3,5)-RIGHT(A3,5)

and then format column c as

h:mm

hope this helps

"msbutton27" wrote:


Thanks but the [t]:mm would produce and error when trying to implement.