Super User
Super User

Questions tagged [utc]

29 questions
113
votes
2 answers

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 be working fine. Related to Does Windows 7…
Dylan
  • 1,735
92
votes
3 answers

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 time. That was / is a big mess, since almoust every…
mru
  • 1,098
50
votes
4 answers

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 output of several programs realtime, many of them…
n611x007
  • 6,566
  • 15
  • 67
  • 91
45
votes
2 answers

Does Windows 8 support UTC as BIOS time?

Is there any way to use Windows 8 with time in UTC in BIOS? I know there is a way to do it in Windows 7 (in this question: Does Windows 7 support UTC as BIOS time?), but this solution makes my system unbootable. Windows expects the bios clock to be…
Roren
  • 553
12
votes
3 answers

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 be best please leave it below as it must be applied…
Brigitte1Trick
  • 121
8
votes
3 answers

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?
André
  • 259
6
votes
1 answer

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 as needed and rebooted the system several…
drdaeman
  • 179
5
votes
1 answer

Set Windows to use system clock as UTC

While dual-booting Windows and Linux, Linux sets the system time to UTC, so Windows thinks it's midnight near mid-morning. Is there any other way to tell Windows to use UTC? I've seen the registry tweak proposed here and other places. This does not…
Cajunluke
  • 2,404
3
votes
2 answers

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, the copying process gets funny and starts…
akis_t
  • 31
3
votes
3 answers

Windows XP clock set incorrectly after resume from sleep

I dual boot Linux and Windows XP on my laptop. I added the following registry key in XP to support Universal Time from the BIOS: HKLM\SYSTEM\CurrentControlSet\Control\TimeZoneInformation\RealTimeIsUniversal The clock is set correctly when I start…
lajos
  • 963
3
votes
2 answers

Windows computer keeps updating to UTC time

I have a new Dell computer running Windows 7 x64 (and no other OS). I live in Mountain Time, as my computer is aware (it says Mountain Time in the Date and Time window, from right-clicking on the taskbar clock and selecting Adjust date/time). …
Daniel H
  • 1,696
3
votes
1 answer

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, it is displaying as 10/28/22 6:12 PM and it…
Sheri Morgan
  • 31
2
votes
1 answer

How to isolate why my system date is going crazy?

The date on my x86 machine is going crazy. When I boot, it's in 1980 (as expected since the CMOS battery is dead). So I NTP sync it with no problems. Some time later (within a few hours, and even within minutes at times), the system ends up around…
kmort
  • 1,731
2
votes
0 answers

Ubuntu 12.04 x32 - Windows 7 Pro x64 dual boot - clock is wrong (UTC)

I have a problem with time when booting windows after linux. The reason is that Ubuntu saves hw clock as UTC but Windows 7 expects it to be saved as localtime. So Windows shows time that is one hour before correct local time. UTC time: 3:35PM Local…
darthcz
  • 31
2
votes
2 answers

How do email servers handle timestamps?

I'm using Thunderbird as my email client to check a Gmail account. I get a lot of emails from family who are located in different time zones. Now, my emails don't arrive out of order, but the timestamps are sometimes out of order so that when my…
Shane
  • 987
1
2