Time in Text- want to convert it

[Neil]

I imported a file that has a column of time valus in this text format 2.11-55

I want that to convert to a known time value so that I can create a chart
using the time as a value. How can I convert it?

 

[mangesh_yadav]

need more examples. And what is 2. Is 11-55 hh-mm? or is the forma
hh.mm-ss?

- manges

 

[mangesh_yadav]

Considering your string format is H.MM-SS and the value is in cell A1
then use the following to convert to time format.

=TIME(LEFT(A1,FIND(".",A1)-1),MID(A1,FIND(".",A1)+1,FIND("-",A1)-(FIND(".",A1)+1)),RIGHT(A1,2))

Manges

 

[mangesh_yadav]

the above soln will work.

manges

 

[Ron Rosenfeld]

I imported a file that has a column of time valus in this text format 2.11-55

I want that to convert to a known time value so that I can create a chart
using the time as a value. How can I convert it?

Assuming that is h.mm-ss, then you may use this formula:

=TIMEVALUE(SUBSTITUTE(SUBSTITUTE(A1,".",":"),"-",":"))

and format it as Time.


--ron