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
Unix time is the number of seconds since the epoch (January 1,1970 - midnight GMT) I don't think that's what the OP is looking for. I think what you want is =HOUR(cell#)-6 (or -7 during MDT)
