Make time series by reading time zone data from excel in python

I thought this would be an easy issue to solve but it took quite some time for me to figure it out and no luck so far.