CayExcel - REST API Tutorial / Demo using Excel VBA

you can try a much simpler way. have a look at this UTC time convert to IST time - #5 by muthukumar7103