|
|
#1
11-04-2011, 05:42 AM
|
|||
|
|||
Excel 2007 and data in dd:hh:mm:ss format
I am using Excel 2007.
I want to draw chart of data that is in dd:hh:mm:ss format. But when I add those cells to chart not is shown on it. I am using scatter/x,y chart. I wonder if Excel isn't recognising the dd:hh:mm:ss format. I didn't find it in standard time-formats so I made custom format for it. Or maybe Excel anyway thinks that those cells are text, not time? How could I make Excel to understand this data? Or how could I convert it to some other form that Excel could use? 
|
| 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 |
Windows 7 64bit 
Office 2007
Threaded Mode