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
John, Thanks for the input. I'm using MSView which is a Morningstar program to collect the data from a MS MPPT60 solar controller on W7. As far as I can determine I have no control over the resulting csv file time format. So a conversion for us humans is in order. The above formula nicely does the job in Excel.
