Super User
Super User

Questions tagged [date-time]

528 questions
97
votes
6 answers

How can I check a system's current NTP configuration?

I need to verify the current NTP configuration on some Windows systems. Ideally, I'd like to be able to do this via command line instead of navigating through configuration screens. (I'm working on several different OS versions, and configuration…
Iszi
  • 14,163
83
votes
8 answers

Windows 7, file properties, date modified, how do you show seconds?

Anyone know a way to immediately show the seconds of a file's date modified property in the GUI? So if you create a file, any file in any directory, right-click and choose Properties, the date modified (if it's recent) will say something like…
Jordan W.
  • 971
55
votes
6 answers

How to change Windows 10 Lock screen time format?

My Windows 10's time format is 24 hour clock, this includes the taskbar but the lock screen is still 12 hour clock format. How do I change the format of my time in lockscreen?
TungstenX
  • 881
39
votes
6 answers

Leap Seconds in Windows

A leap second was recently added on June 30, 2015 23:59:60 UTC. How are leap seconds implemented in Windows (specifically Windows 7)?
Steven
  • 28,386
39
votes
5 answers

Force date/time/clock sync

My Snow Leopard macbook is set to Set date and time automatically: Apple Americas/U.S. (time.apple.com), but despite sitting idle for several hours (with internet connection), it has yet to do any syncing, the date remains off by ~2 days.
user73728
35
votes
2 answers

How do you retrieve the current time on a server?

I want to know the time on a server accurate to the millisecond. there's this way: local $ ssh user@servername Welcome to server! server $ date Fri Feb 18 11:27:50 EST 2011 But I need more accuracy. Is there a command that will be more precise?
user2254
  • 663
31
votes
6 answers

Automatically sync Windows time more often than default

I have a few PCs that are losing time and I'd like Windows to sync them more often with the Internet time. I think the Windows default attempts to update only once per day, and does not update if the time server is not available (which seems to…
DermFrench
  • 697
30
votes
10 answers

Windows 7 time keeps changing by itself

As the title suggests windows time keeps changing in random times, with random amounts. It sometimes happens every minute, sometimes it is good for hours. If I go hit synchronize with Internet time, it updates to the correct time. Things I…
kali
  • 388
30
votes
7 answers

Using Date and Times in a batch file to create a file name

I am running a program from a batch file, which when it is done performs an automatic backup of my MySQL database. I would like the batch file to create a different back up for each run, so I can backtrace. The desired filename would be…
guyfromfl
  • 403
29
votes
11 answers

How to prevent Excel to use the OS regional settings for date patterns in formulas

According to this question I have the following problem: I want to use some Excel function (not the cell formatting) like TEXT(A1, {date_pattern}) But the person who answer my previous question make me found that the date pattern change according to…
рüффп
  • 763
27
votes
4 answers

Internet Time tab has disappeared from the Date and Time applet of the Control Panel

Previously, there was an Internet Time tab on the Date and Time applet of the Control Panel, wherein one could force a query of an internet time server and also type in a different server from the ones supplied. However, this tab has now…
Animadversor
  • 478
26
votes
7 answers

Is there any way to properly display negative time spans in Excel?

Is there any way to make Excel show a negative time span? If I subtract two time values (say, when subtracting the actual amount of time spent on something from the amount of time planned for it) and the result is negative, Excel just fills the…
Pepor
26
votes
2 answers

What is this 14-digit time format from Windows registry?

Microsoft Office 365 saves information in the registry about what time it last searched/downloaded/applied updates in a format like this: Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\office\ClickToRun\Updates' | select…
Cpt.Whale
  • 10,914
25
votes
8 answers

Can't Sync Windows 10 Clock to The Internet

I am having a serious problem with my computer. I simply can't sync the clock on my windows 10 running machine to the internet. When I go to "Date and time settings" and turn the "Set time automatically" switch off and then back on, it either loads…
Awusuwah
  • 351
24
votes
5 answers

How to get time difference as minutes in Excel?

I have time values in two cells in an Excel sheet and I need the difference of the times in minutes. The cells in the Excel are like below: A B C 1 6:38 8:23 1:45:00 A is the start time B is the end time C is the time…
SrinR
  • 375
1
2 3
…
35 36