Questions tagged [date-time]
The date-time tag has no usage guidance.
60
questions
83
votes
9
answers
108k
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 ...
28
votes
11
answers
128k
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 ...
13
votes
7
answers
17k
views
Windows 10 always showing wrong time (when dual-booting with Ubuntu)
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-...
91
votes
6
answers
1.5m
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 ...
54
votes
6
answers
97k
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?
17
votes
8
answers
102k
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 ...
11
votes
2
answers
20k
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
3
answers
33k
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 : `=...
3
votes
2
answers
2k
views
Time does not update automatically on Windows 10
I have a really big problem with the time on windows 10. Every time I start computer, I have to manually set the correct time. I don't know what the problem is. In settings "Set time automatically" is ...
30
votes
7
answers
306k
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 ...
30
votes
10
answers
148k
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, ...
29
votes
6
answers
65k
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 ...
24
votes
8
answers
148k
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 ...
22
votes
5
answers
156k
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 ...
17
votes
2
answers
12k
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 ...
15
votes
1
answer
109k
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 ...
8
votes
13
answers
108k
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
4
answers
23k
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 ...
6
votes
3
answers
7k
views
Customise date-time format in Windows
Is it possible to customize data (or date-time) format in Windows (I am using Windows XP)?
The current format which is followed by the OS [to show date-modified, etc.] is MM/DD/YYYY or M/D/YYYY, ...
3
votes
1
answer
4k
views
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...
3
votes
3
answers
2k
views
Time an hour off when booting between Windows and Fedora
I'm currently having some bother with a dual boot box running Windows XP and Fedora. Whenever I reboot into the other operating system, the time is an hour out - when going from Fedora to Windows, it'...
1
vote
3
answers
43k
views
How to change date format from dd-mm-yyyy to dd-mm-yy in formula bar of MS-EXCEL?
I've written a date in one of the cells of MS Excel spreadsheet as 26-09-2013. Then by right clicking on that cell I selected Format cells and gone to Number->Date option and by selecting the type ...
1
vote
1
answer
1k
views
How to add missing options (control panel in start menu & date format) in Windows 10 Creators update? [closed]
I recently updated to the Windows 10 creators update and noticed that the option to access the control panel was removed from the start menu and an option for the date time format as well.
Is there ...
1
vote
3
answers
8k
views
cmd: include date and time to filename
How can I get a filename YYYY.MM.DD_HH.MM.SS.7z? It should work with any regional settings!
The question is not duplicating 7-Zip CMD: Add current date to archive and include only the last modified ...
0
votes
2
answers
2k
views
PowerShell, why does CreationTime expect US date format while system has European date format?
I've digitised my old VHS tapes and it's now quite a lot of separate files. I want to set the filedates to the 'original' dates of the events, so that I can sort them chronologically.
This can be ...
-1
votes
2
answers
4k
views
How to divide a time period into equal periods in Excel
I would like to find a way of dividing a period of time into 4 hourly time zones. I.e. if a piece of equipment is unavailable from 0900hrs to 1700 hrs that is 8 hours but I need to show this in 4 ...
39
votes
6
answers
6k
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)?
27
votes
4
answers
138k
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
7
answers
26k
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
2
answers
49k
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 ...
19
votes
11
answers
39k
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
6
answers
55k
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
1
answer
250k
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?
15
votes
3
answers
73k
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
2
answers
21k
views
Is there any way to view dates of changes to Windows registry keys/values?
Is there any sort of date tracking that is done or viewable in the Windows registry, such as seeing the date when X key was created, or Y key was modified, similar to how file systems track?
I'm ...
10
votes
6
answers
68k
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 ...
9
votes
5
answers
41k
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 ...
8
votes
4
answers
48k
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 ...
6
votes
9
answers
32k
views
How to insert time and date, and the directory path in Notepad++?
I just downloaded Notepad++ v 5.3.1 and I'm having two problems with the TextFX plugin:
I recorded a macro with "TextFX Insert" > Date & Time (no matter whether short or long format) ...
5
votes
4
answers
35k
views
How to calculate hours and minutes between two time periods?
I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods.
I have a field: timestart which could be ...
5
votes
5
answers
10k
views
How to insert date/time in notepad++ 64bit
Old question are about 32-bit. And they are working on 32-bit.
But in 64-bit notepad++ there are much less working add-ons, so the fastest solution: open simple notepad, press F5 and copy date-time ...
5
votes
2
answers
48k
views
Windows 10 automatic daylight savings adjustment not working?
I have a single Windows 10 machine. It is not connected to a domain. Pretty stock. Daylight savings time changed this weekend, and my computer is not showing the correct time. I've rebooted it with no ...
4
votes
2
answers
3k
views
How do you format an Excel date to represent >31 days with hours, minutes and seconds
Let's say A1 contains a value which is the number of days in duration. Example:
57.121875
That number represents the number of days.
I would like to use an excel format which ultimately makes it ...
4
votes
3
answers
3k
views
Is there a clock application with deciseconds (HH:MM:SS.d)?
You may wonder, But I am interested in a clock app that in addition to second show decisecond.
I deeply searched and could not find one yet, did you know any app (desktop gadget/system tray clock) ...
3
votes
1
answer
5k
views
How to add time duration column total from Skype Call History CSV file in Excel 2010?
How to add time duration column total from Skype Call History CSV file in Excel 2010?
These are my exact steps on how to set up my Excel spreadsheet.
How to import Skype Call History CVS in Excel ...
3
votes
1
answer
4k
views
BIOS date/time reset
After 5 years of heavy use, I noticed that my laptops fan is constantly on, so I decided to change the thermal paste of the cpu. Everything went fine except for some strange reason my laptop keeps on ...
3
votes
2
answers
615
views
How to display the current "Day of the Week" next to the 24H time in Windows 10?
I would like to see a short two letter day of the week abbreviation like MO for Monday SA for Saturday before the 24H time dusplay on windows 10.
As you can there's plenty of room there. For most ...
2
votes
1
answer
33k
views
Where is the Daylight saving time setting in Windows 7?
I can't find how to disable the Daylight saving time option in windows7 !
2
votes
2
answers
8k
views
Why does Excel treat some dates differently than others?
I have a CSV file that contains strings meant to be interpreted as dates with minutes, seconds and miliseconds.
In particular entries look like this:
"07/31/2013 23:59:32.864",otherdata,moredata
"08/...
2
votes
4
answers
6k
views
How to calculate age in years?
In Excel 2010, I'm using the formula =(TODAY() - 05/31/1996) / 365.25 to calculate the age in years between today's date, May 30, 2013, and May 31, 1996. I'm expecting some number close to 17.00, but ...