chart of line graph for date v/s sunset time

[BK LAAL]

Hi
I am not able to plot date v/s sunset time graph

This is because excel is not able to understand the date and time format.

Even Text to column technique not working for date fields

This data I have exported from a website into this excel.

Please help me formatting this data in its correct format.

 

[Debraj]

Hi Bk,

Check the attached.. hope you like it..

 

[Hui]

Nice Chart Deb !

Bk, Your data in Columns B:D is text, not Date/Time
Deb has converted the data to Dates/Times in Columns N: P using the Datevalue() and Timevalue() functions

To learn more about Dates and Times and how Excel manages them, have a read of:
http://chandoo.org/wp/2013/10/17/excel-date-time-tips/