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
UTC formerlly called Greenwich Mean Time.
EST (Extra Smart Time) UTC-5 hours EDST (Extra Dumb Stupid Time) -4hours
CST -6 CDST -5
MST -7 MDST -6
PST -8 PDST -7
Windows 8.1 lets you program two clocks, Set one to London time or UTC and then your computer will translate present time for you. You can eventually learn the pattern
I keep two sets of clocks in one room (Radio room) Because I use UTC for logging, I also have an app on my older (XP) boxes, have not yet put it on the 8.1 box, that puts a UTC clock in the upper corner. Thanks for the reminder.
EST (Extra Smart Time) UTC-5 hours EDST (Extra Dumb Stupid Time) -4hours
CST -6 CDST -5
MST -7 MDST -6
PST -8 PDST -7
Windows 8.1 lets you program two clocks, Set one to London time or UTC and then your computer will translate present time for you. You can eventually learn the pattern
I keep two sets of clocks in one room (Radio room) Because I use UTC for logging, I also have an app on my older (XP) boxes, have not yet put it on the 8.1 box, that puts a UTC clock in the upper corner. Thanks for the reminder.
