Questions tagged [utc]
The utc tag has no usage guidance.
28
questions
1
vote
2
answers
193
views
EXIFTOOL, track creation date, and timezone
I am trying to make sense of the QuickTime/TrackCreateDate value obtained for a file created by camera recording on an iPhone 15, latest OS. In this case, I was in Japan at the time. According to ...
- 1,489
3
votes
1
answer
22k
views
Excel - UTC to EST Formula
I have a UTC timestamp that looks like this in Excel:
2022-10-28T18:12:23.603Z
I need the information to appear as 10/28/22 hh:mm:ss AM/PM format but I need it to come out in EST timezone. Right now, ...
- 2,081
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 ...
108
votes
2
answers
168k
views
Does Windows 10 support UTC as BIOS time?
EDIT 2015-SEP-30:
Seems I actually ended up with localtime enabled in Linux somehow, probably as a consequence of a reinstall some time ago. I switched Linux to UTC and now my configuration seems to ...
- 103
0
votes
0
answers
21
views
WHat is wrong with gmt-5 and gtm+5 timezone files in linux [duplicate]
I am in EDT time zone and I would like to use GMT-5 to convert time to EST (GMT-5 and EST should be the same I think). But GMT-5 results in +5hr offset from UTC which I would expect GMT+5 should be ...
1
vote
0
answers
330
views
Windows Time Sync issues cmd.exe & svchost running
I have a strange issue that is happening with our time syncing error for a computer at work.
Randomly the PC changes time to a year,few minutes, hours back. Example: before the glitch it will be ...
0
votes
2
answers
1k
views
How can I remove the letters “UTC” from the time in a column of cells with date and time entries?
I have cells in a spreadsheet with the date and time in UTC (over a thousand of them).
I want to remove the letters UTC as I need to import the document elsewhere and it doesn’t work with the letters ...
- 56.1k
1
vote
2
answers
518
views
Changed UTC time dumps after reboot in Arch Linux
I use Arch Linux OS with Linux 5.4.61-1-lts kernel, x86-64.
I noticed, that my UTC time is wrong:
[tao@dc ~]$ timedatectl
Local time: Sun 2020-08-30 12:15:41 EEST
Universal ...
- 11
2
votes
2
answers
2k
views
exFAT file timestamps
I use external SD cards to backup important data on my PC. I typically use "Robocopy /mir /ndl" so that I get on the SD card a true picture of what's on the disk.
Twice a year, when the clocks change,...
- 154
92
votes
3
answers
97k
views
Does Windows 7 support UTC as BIOS time?
Since I live in Germany, my timezone is GMT+1 (or GMT+2 in the summertime period).
Previous Windows versions were not able to have the hardware clock set to UTC, and the Windows time to the local ...
0
votes
1
answer
564
views
Debian still using UTC
/etc/localtime is a symlink to Budpaest
/etc/timezone is Budapest
root@server:~# cat /etc/adjtime
LOCAL
root@server:~# date
Sun Aug 6 06:58:42 UTC 2017
So all my crons using UTC, how can I use ...
- 101
0
votes
0
answers
307
views
Format Excel datetimes with fixed widths and typical software formats
How can Excel be used to format dates with fixed widths using formats typical to software applications (MySQL DATETIME format, ISO 8601, RFC3339)? While it would be "nice" to convert to UTC, I am ...
- 1,691
49
votes
4
answers
34k
views
A Windows clock to show both UTC and local time?
I'm working on windows 7 x64 and searching for a way for a setting, or replacement app of, the tray clock (on the taskbar corner) to display both UTC (or GMT) and my local time.
Cause: I read log ...
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?
- 111
6
votes
1
answer
2k
views
Windows 7 set to UTC RTC forcibly changes time
I really want to make Windows 7 understand that RTC in using UTC instead of local time. I found a solution, except for it does not play well with time synchronization.
I have:
Modified the registry ...
CommunityBot
- 1