All Questions
2
questions
8
votes
3
answers
87k
views
How to convert UTC to typical date format in Excel?
I have this UTC column called Timestamp. It looks like this.
2019-06-27T23:01:12.1024861Z
How do I convert it so it looks like this in Excel?
06/27/2019 23:01:12
If there is a formula that would ...
8
votes
3
answers
72k
views
How to change the date of Linux to UTC/GMT +1?
I need to change the date of my system. I'm running a Linux CentOS 5.6.
# date +%Z
UTC
# date
Thu Oct 6 11:42:45 UTC 2011
How do I change the hour to be UTC/GMT +1?