Hi Sammael,



For a 'dd:hh:mm:ss' string in A1, the following formula will convert the 'hh:mm:ss' portion to a timevalue:
=TIMEVALUE(RIGHT(A1,LEN(A1)-FIND(":",A1)))
or, if you also have different days for some of the times:
=TIMEVALUE(RIGHT(A1,LEN(A1)-FIND(":",A1)))+LEFT(A1,FIND(":",A1)-1)
Once you've done that for all the cells, you should be able to use the column containing the timevalues in your chart.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Excel wont accept those formulas. Says that there is error in them.
I changed A1 to correct cell in my sheet.

When giving error Excel bolds the following part of of the code in tools tip that appears: RIGHT(text;[num_chars]).