Convert JSON Date to Excel Date

Originally Posted by davsth

what is the +0530 ?

the first part converts to a date 22/1/2018 18:30 but what is the second part? and offset of that number of hours?

It is the value of the time zone..