![]() |
|
#4
|
||||
|
||||
|
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] |
| Tags |
| date, excel 2007, time |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to create microsoft Excel 2007 and 2010 File in .xlsx format | ipacesetters | Excel | 1 | 12-16-2019 05:13 PM |
Excel 2007 cell format help!!!
|
Raner | Excel | 4 | 06-17-2013 11:13 PM |
Excel 2007 data question
|
Paul-NYS | Excel | 3 | 09-26-2011 10:49 PM |
| How to restore original data format - from a .pdf file to Excel columns | KIM SOLIS | Excel | 1 | 09-18-2011 10:49 PM |
Format Excel to look like Word
|
Kilconey | Excel | 1 | 04-30-2010 09:42 AM |