Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
83
votes
9answers
103k views

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 ...
80
votes
6answers
1.3m views

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 ...
48
votes
6answers
90k views

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?
39
votes
6answers
5k views

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)?
34
votes
5answers
28k views

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 ...
30
votes
2answers
141k views

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....
30
votes
10answers
145k views

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, ...
27
votes
11answers
110k views

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 ...
26
votes
6answers
258k views

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 ...
26
votes
4answers
118k views

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 ...
24
votes
5answers
121k views

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 ...
23
votes
5answers
48k views

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 ...
23
votes
5answers
24k views

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 ...
22
votes
2answers
5k views

Auto Insert date into Notepad

I am using Notepad - the standard plain old plain old in Windows 10 Home 64. I had been typing up some notes and one of my sentences was not correct - I accidentally pasted some text over what I was ...
22
votes
2answers
45k views

How to disable time sync with Windows 7 as host OS in VirtualBox?

I have a 64 bit Windows 7 with VirtualBox running the same 64 bit Windows 7 as a guest OS. When I set a specific date and time, it will always revert to the host OS’s date and time on startup. How ...
21
votes
5answers
143k views

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 ...
18
votes
11answers
35k views

How to show weekday in Windows 10 clock in taskbar?

In all windowses before 10 I could just pull the taskbar up and I could see which day it is: But when doing that in Windows 10 it doesn't work: How can I get my weekday back without having to hover ...
18
votes
6answers
54k views

Automatically change time based on current location

I often move between 2 time zones, and expect my Windows 7 laptop to somehow automatically change the system time, being spoiled by the same feature on my cell phone. I always assumed that desktop O/...
17
votes
1answer
241k views

How to concatenate a date in MS-excel and receive a date (not a number)

When I try to concatenate two cells in MS-excel in the formula I have the date as a integer number (eg: 04 april 2012 become 41006). How can I display the date also in the formula cells?
16
votes
7answers
88k views

I get "An error occurred while Windows was synchronizing with [name of time server]." when trying to automatically synchronise PC time

Prompted by the answers to this question I decided to give the Windows built in time synchronisation another go. However, no matter what time server I use I get this error: "An error occurred while ...
15
votes
5answers
7k views

Use ISO time and date format in KDE 5

I've been using Dolphin for organising pictures. I would like to see the modification time and date displayed in ISO format. It is easier to read for me. I used to be able to configure that in KDE 4: ...
14
votes
1answer
99k views

Formula to add minutes to date+time in Excel

If I have a cell formatted as date+time in Excel, how can I add to this in terms of minutes? It would need to work whether I was adding 20 minutes, or 2,500 minutes. So, for example if I had this ...
14
votes
8answers
141k views

Change year in many date fields in excel?

So I've noticed in a worksheet I have many dates that are four years off, no doubt because of improper copy/paste from earlier question. Is there an easy way to convert a bunch of dates I select to a ...
14
votes
2answers
9k views

How to make date YYYY-MM-DD (ISO-8601) the default in Excel?

In Excel how can I make the ISO8601 date format, yyyy-mm-dd, the default? Windows locale is English(CA) or English(US). We're using Excel 2013, though a generic answer for as many versions as possible ...
13
votes
1answer
2k views

How to get rid of fractional seconds in find using -printf?

I'm running this shell command to get the most recent 20 PHP files modified on my server. find . -name '*.php' -printf '%TY-%Tm-%Td %TH:%TM:%TS %Tz %p\n' | sort -r | head -20 The output is like this:...
13
votes
2answers
24k views

Disabling time synchronization with Hyper-V

I found that when attempting to change the Date/Time settings on a Hyper-V virtualised Windows 8 OS, I found that the date would immediately change back to the correct date. How can I prevent the ...
12
votes
3answers
59k views

What Excel formula can I use to calculate the 2nd Monday of a given month?

What Excel formula can I use to calculate the second Monday of a given month? You can assume I have a cell containing the first day of the month to work with. In the interests of other users, can ...
11
votes
6answers
14k views

Windows 10 always showing wrong time

This is driving me crazy. For some reason Windows 10 is showing me the UTC +00:00 London time instead of UTC +01:00 Vienna although I set it accordingly: If I disable "Set time automatically" and re-...
11
votes
3answers
92k views

Can't synchronize time, Windows 7

Ok, I finally installed Windows 7, clean install. Time synchronization does not work. Clicking "Update now" gives message: Unable to start the Windows Time service. Please try again later. I use ...
11
votes
2answers
19k views

How much clock drift is considered normal for a non-networked windows 7 PC?

I have a stand-alone PC with no network connection running Windows 7 (64bit) and the system clock loses about 1 minute per week. Is this level of drift considered "normal" or is it a dodgy RTC or a ...
10
votes
6answers
55k views

Calculate number of Sundays in the month

In Microsoft Excel I am looking to determine the number of Sundays in any given month. I am putting together a budget spreadsheet and some of the sub accounts get extra funding when five Sundays are ...
10
votes
2answers
5k views

Linux - Forcing 24-hour locale?

Is there any way to force 24-hour time in my locale (for example, 14:00) instead of 12-hour time (2:00 PM)? I use the en_US locale with a UTF-8 character set on Arch Linux, but this shouldn't matter, ...
10
votes
2answers
18k views

How can I change the default date format?

When I paste a date into Excel 2010 in the format "2012-12-07 00:00:00.000" I'd like it to be displayed by default as "2012-12-07", but it is actually displayed as "00:00.0". I know I can work ...
9
votes
5answers
38k views

Why is my NTP controlled computer clock two minutes ahead?

The clock in my computer is configured to be synchronized using NTP. To verify this I have tried two NTP clients using various NTP servers. My computer and the NTP clients are in complete agreement ...
9
votes
3answers
4k views

Calculating the number of days between two dates in Excel

I consider 7 days to be a week, so if I look at 1 January 2019 - 7 January 2019, I would say that is 7 days.  But often I seen when people are calculating the number of days between two dates or age ...
9
votes
3answers
20k views

Windows 8/10 date format dd/mm/yyyy

Is it possible to change the date format for Windows 8/10 to be dd/mm/yyyy with the separator being specifically (/)? Is the only way to do it in the registry? Start program regedit.exe (via ...
9
votes
4answers
61k views

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)?

How can I get the displayed value of a cell in MS Excel ( for text that was converted to dates)? Excel File Origin I have an Excel file that was originally a CSV file. At this time I don't have ...
9
votes
3answers
15k views

Change default calendar starting weekday in Windows XP

In the "Date and Time Properties" dialog of Windows XP (reachable by double-clicking on the time/date on the taskbar) the week in the calendar starts on Monday. I would like to change it so that it ...
9
votes
1answer
5k views

Change OS X date and time format in menu bar

Basically I want to change the date/time that appears on the right side of the menu bar in OS X to only display numbers (like Windows). I've managed to add dates but currently it shows: 10 Aug 10:49 ...
8
votes
3answers
1k views

Directly open the "Set the time and date" dialog in Windows

For testing purposes, occasionally, I need to change the date and time of the OS. I would really like to have a direct access to the window which allows me to do just that. (In windows 10, you have ...
8
votes
2answers
37k views

How to sync windows 10 clock to internet from commandline?

I would like to be able to synchronize my windows 10 computer clock when it goes out of sync... From the commandline with 1 command. This solution shows how to do it via settings. https://superuser....
8
votes
4answers
43k views

Custom Date Format in MS Word 2010

I have a date field in a Word document which was created from a template included with Microsoft Word 2010. The default setting for this field is to display only two places of the current year. I ...
8
votes
2answers
91k views

How to set system time on Kali linux?

I am trying to set the time, using e.g. date -s "11/20/2003 12:00:00" however, after a few moments, the system time resets to the current time. What am I doing wrong? NTP should not get a different ...
8
votes
1answer
6k views

How can I set 24 hour time in KDE5

It seems the new way to set your preferred date format is by country and language. I've never thought about this method but I guess it encourages people to be more multicultural, researching how ...
8
votes
2answers
5k views

Clock running fast after OS X Mavericks install

I've noticed my OS X system time on my iMac is running faster after I updated to Mavericks, after about a week it is a good 4 or 5 minutes too fast. In my Date & Time preferences everything is ...
7
votes
12answers
99k views

How to stop Excel Treating US dates as UK dates?

I'm in the UK, I've got a problem where I've got a list of dates supplied in US format. Excel seems to treat the ones that are valid in both formats as UK dates, (e.g. 03/01/2012 becomes 3rd of ...
7
votes
4answers
6k views

Linux runasdate analogue

I want some user (or some process) to have different time and date. Is it possible? How can I do this?
7
votes
1answer
20k views

Converting Unix Time into Human Readable Format in Excel

I have a spreadsheet containing several timestamp columns, given in Unix time, i.e. number of seconds since 01/01/1970 00:00.00 UTC. Using Excel 2010, are there any methods, and if so how, to ...
7
votes
3answers
24k views

Excel TEXT function does not work properly

Let say I have the following values in the cells A1 : `=Now()` which displays 17.03.2014 13:45 A2 : 12.03.2014 Both are in date format and I have the function in another cells like this: B1 : `=...
7
votes
4answers
22k views

How do I calculate number of hours > 24 in Excel?

I've got an excerpt of my spreadsheet below. It's a time tracking application containing a start date/day, a session ID and the duration of the session. Column A is populated by adding the duration in ...

1
2 3 4 5
10