• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

chart of line graph for date v/s sunset time

B

BK LAAL

Member
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.
 

Attachments

  • sunset_bklaal_chandoo.xlsx
    17 KB · Views: 3
Hi Bk,

Check the attached.. hope you like it.. :)
 

Attachments

  • sunset_bklaal_chandoo.xlsx
    19.5 KB · Views: 20
  • Like
Reactions: 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/
 
Last edited:
You must log in or register to reply here.
Back
Top