Date-time format in Excel 2010...how is it meant to be!?

I have a large data file with a good 30,000 entries so far.

Upon plotting the data, I hit a problem.

I have a column with the date in and a column with the time in...

Format: Date: 03/05/2015 (dd/mm/yyyy) Time: hh:mm:ss

When combined as 03/05/2015 08:40:03 for all entries, when plotting, the chart ignores any gaps in the data (chronologically). I want this to be as a data vs time chart with any gaps in data recording being shown.

I ahve included a copy+paste here to show my data with a "data blip" where the unit has restarted due to a problem/bug.

UNIX TIME Date Time H1 T1 H2 T2 Light Data entry ID

Please Login or Register  to view this content.

Thanks! Find it a bit odd excel can not simply see a very common date+time scenario and know what you want...

I don't understand what your question is. Can you upload an Excel file that shows a small sample of the data and the problem you are having?