Converting UTC Date Time in Excel
My solar controller produces data with this UTC time stamp. How can I convert this to a simpler format in Excel? Convert these controller UTC times: 2014-12-24T23:59:04.050+00:00 2014-12-25T00:...
Forum Discussion
There is probably a more eloquent solution out there, but if you put your UTC time in column D and this formula in Column E, it should work during MST. Format Col E to custom hour, minute, second AM/PM
=TIME(IF(MID(D1,12,2)="00",17,IF(MID(D1,12,2)="01",18,IF(MID(D1,12,2)="02",19,IF(MID(D1,12,2)="03",20,IF(MID(D1,12,2)="04",21,IF(MID(D1,12,2)="05",22,IF(MID(D1,12,2)="06",23,MID(D1,12,2)-7))))))),MID(D1,15,2),MID(D1,18,2))
Good luck,
Norman
=TIME(IF(MID(D1,12,2)="00",17,IF(MID(D1,12,2)="01",18,IF(MID(D1,12,2)="02",19,IF(MID(D1,12,2)="03",20,IF(MID(D1,12,2)="04",21,IF(MID(D1,12,2)="05",22,IF(MID(D1,12,2)="06",23,MID(D1,12,2)-7))))))),MID(D1,15,2),MID(D1,18,2))
Good luck,
Norman
