76

Same here; I was able to get the lock screen to show HH:MM via my personal account with admin privileges, no hidden admin account needed. This is how: Press Win+R, type intl.cpl and press Enter (this will open "Region" settings) Set your "Short Time" & "Long Time" formats in the window that comes up, then click "Apply." Select the "Administrative" tab ...


40

If you want to insert the date and time into Notepad, press F5.


35

How the Windows Time service treats a leap second The Windows Time service does not indicate the value of the Leap Indicator when the Windows Time service receives a packet that includes a leap second. (The Leap Indicator indicates whether an impending leap second is to be inserted or deleted in the last minute of the current day.) Therefore, ...


35

Windows is normally acting as an NTP client. It will just get its time up to date during the next update from the NTP server, which clearly has methods of handling leap seconds. This will happen, provided your system is setup to synchronize time via NTP. If it is not, then nothing will happen as Windows 7 does not have built-in functionality to deal with ...


32

This is the way Excel sees dates. To see them the way you want they have to be formatted and when alone in a cell that can be done by changing the cell's formatting. When you want to combine a date with other things, such as text, you need to use formula to format the date the way you want. Here's how: Use the TEXT formula to change the date to text in the ...


30

This question is a bit old, but to date it does not seem to have an answer. I've also seen similar questions on a number of sites, but have not yet found any answer that involves only built-in Excel functions. However, it is quite easy to solve this with VBA. You don't even have to know how to program to do this, because the required function is so simple. ...


25

You would need to divide the number of minutes by 1440 (24 hours in a day × 60 minutes in an hour) and then add that to the date. =B4+(B3/1440) or if you want to be more verbose... =B4+(B3/24/60) The reason this works is that Excel date+time values are stored as a floating point decimal number representing the number of days that have passed since ...


23

The weekday will be shown on your horizontal taskbar when you either Have Small Taskbar Icons enabled and the Taskbar is at least 3 rows high or Have Small Taskbar Icons disabled and the Tasbar is at least 2 rows high If you use the vertical taskbar You need to have it at least 80 pixels wide @ 100% scaling If you can't pull on your taskbar to resize it ...


22

I've figured out a better answer than hacking the registry... Thanks to zppinto for putting me on the right track. The problem remained that the time format was still US when no user is logged in. First activate the hidden administrator user account: Run the Command Prompt as administrator Type in net user to see all the user accounts Type in net user ...


22

Find the location where your Virtual Machine is stored. You can do this by right clicking on the machine from the list in the VirtualBox Manager and selecting Show in Explorer Backup the file called yourVMname.vbox Open the file in a text editor and navigate to the <ExtraData> element which should contain a list of ExtraDataItem elements Add the ...


20

This answers your last question: Open a command prompt and type exactly: w32tm /stripchart /computer:NTPServerNameOrIP /dataonly /samples:x (how many returns you want) It returns time and difference to NTP server time. If it returns time, error: 0x80072746 then that is not your NTP server. An example of a command is below:


19

The command to disable time synchronization between host and guest in Virtualbox is: VBoxManage setextradata "VM name" "VBoxInternal/Devices/VMMDev/0/Config/GetHostTimeDisabled" 1 See the Virtualbox manual, section 9.14, especially 9.14.4. Note that in a Windows host your command window's default directory must be in the directory where Vboxmanage.exe ...


19

First of all, this is more than a decade old Windows problem! This is nothing new! Windows has had problems syncing the system time against NTP servers for as long as I can remember. If you must use the Internet to get an accurate system time, then use one of the American NIST's NTP servers. Don't use the Microsoft NTP server! It never works! It has never ...


19

I had a similar problem on Dual Boot PC (Win 10 & Ubuntu 18.04). The issue was that Windows tries to keep hardware clock (a.k.a BIOS clock) at the local time, but Ubuntu tries to keep it at the UTC time. So the OSs fight each other, changing the hardware clock time each time they boot. The solution is to either make Ubuntu use local time, or make ...


17

You can use the GUI to set a custom date format for any given region: Open the Region control panel (intl.cpl from a terminal). Click Additional settings... at the bottom-right of the window. The Customize Format window will appear, click the Date tab. In the Short date field, enter your desired format. For example: d/M/yyyy. Click apply, and the changes ...


16

Start a PowerShell or CMD with elevated rights and use the W32tm command: W32tm /resync /force For further reading: interesting article about the difference between NET TIME and W32tm.


16

It is not a question of one formula being right and the other being wrong. It is a question of what you are looking for. Say you are working on a task 24 hours a day. You begin the task 17 January 2000 at 9:00 AM and complete the task 18 January 2000 at 9:00 AM. If the question is How many days did the task take ? You would take the difference; get 24 ...


15

You can create a shortcut pointing to timedate.cpl


14

You can truncate the fractional part using the %.n formatting syntax, where n is an integer specifying the length of the string you want to keep. In your particular case, the incantation would be: find . -name '*.php' -printf '%TY-%Tm-%Td %TH:%TM:%.2TS %Tz %p\n' | sort -r | head -20


14

Open the 'Hyper-V Manager' application on the host machine. On the list of 'Virtual Machines', right-click on the VM where you want to change the Date/Time settings and click 'Settings'. Under the 'Management' section of options, select 'Integration Services', and uncheck the 'Time synchronization' option. When changing the Date/Time settings from ...


14

In addition to the F5 method (which wrt your last paragraph I understand exactly answers your question), you can also use the auto-timestamp feature by starting the file with .LOG This will ensure the timestamp is added each time you reopen and edit the file.


14

The answer revolves around how Excel deals with dates. When days between dates are calculated using formulae such as B1-A1, Excel would turn the dates into serial numbers and use the serial numbers to calculate the number or days in between. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 ...


13

Your code works fine for me. Although I have to use B1 : =TEXT(A1,"dd.mm.yyyy") B2 : =TEXT(A2,"dd mm yyyy") I am guessing the reason I use , instead of ; is due to the difference of language. The fault is more likely to be due to dd.mm.yyyy For example, I know in Germany, I can't use dd because d (day) in German is tag, and as such it requires tt ...


13

Try this where A1 is the starting day of the month: =SUMPRODUCT(N(TEXT(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))),"ddd")="Sun")) You can also use this for any day of the week just change "Sun" and any date range by replacing A1 with start date and EOMONTH(A1,0) with end date.


12

I find en_SE to be fully ISO-compliant: YYYY-MM-DD HH:MM (24h) Whereas for me en_DK uses DD/MM/YYYY HH.MM (24h) which is not ISO compliant both in the date order (it's simply a western europe order) and in the time separator. en_CA uses YYYY-MM-DD hh:MM (12h) likewise close but uses AM/PM rather than 24h. Tested on KDE Plasma 5.11.3, running on Arch Linux....


11

Go to Control Panel > Administrative Tools > Task scheduler left is an folder tree, expand: Task scheduler library > Microsoft > Windows > Time synchonization right click the task: SynchronizeTime > properties On the tab: Triggers you can add the triggers you want.


11

The ".DEFAULT" system internationalization settings can be found in the following registry key: HKEY_USERS\.DEFAULT\Control Panel\International Update the following values to match those of your user settings: sTimeFormat (likely: H:mm:ss) sShortTime (likely: H:mm) Note: Your user settings can be found in: HKEY_CURRENT_USER\Control Panel\International


10

I tried: w32tm /query /status I got: The command /query is unknown. In a different machine, I got: The following error occurred: The service has not been started. (0x80070426) Then I tried: reg QUERY [\\machine\]HKLM\SYSTEM\CurrentControlSet\Services\W32Time I got: ERROR: The system was unable to find the specified registry key or value. Then I ...


10

If the date you mention is always the first of the month, then this one will also work: =INT((WEEKDAY(A1-1)+EOMONTH(A1,0)-A1)/7)


10

Go to: Control panel -> Clock and region -> Region in Region 'Format' tab go to 'Additional settings' in the date format box you can change short date. My format is : M/dd-ddd


Only top voted, non community-wiki answers of a minimum length are eligible