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?
|