Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
Jordan W.'s user avatar
  • 971
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 ...
рüффп's user avatar
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-...
Stefan Falk's user avatar
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 ...
Iszi's user avatar
  • 13.8k
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?
TungstenX's user avatar
  • 871
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 ...
ChrisF's user avatar
  • 41.3k
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 ...
RossFabricant's user avatar
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 : `=...
рüффп's user avatar
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 ...
irakliy01's user avatar
  • 133
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 ...
guyfromfl's user avatar
  • 403
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, ...
kali's user avatar
  • 369
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 ...
DermFrench's user avatar
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 ...
Awusuwah's user avatar
  • 341
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 ...
SrinR's user avatar
  • 355
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 ...
matt wilkie's user avatar
  • 5,133
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 ...
Drew Chapin's user avatar
  • 6,010
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 ...
deworde's user avatar
  • 260
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 ...
dwwilson66's user avatar
  • 1,749
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, ...
Rookie Programmer Aravind's user avatar
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 ...
sarah vac's user avatar
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'...
Scott's user avatar
  • 5,913
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 ...
Anand Jaju's user avatar
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 ...
FewL's user avatar
  • 367
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 ...
noober's user avatar
  • 233
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 ...
BdR's user avatar
  • 201
-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 ...
Callie's user avatar
  • 1
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)?
Steven's user avatar
  • 27.9k
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 ...
Animadversor's user avatar
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 ...
user avatar
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 ...
rovyko's user avatar
  • 1,206
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 ...
Gizmo's user avatar
  • 1,949
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/...
Suan's user avatar
  • 487
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?
Ale's user avatar
  • 746
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 ...
Highly Irregular's user avatar
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 ...
Coldblackice's user avatar
  • 5,884
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 ...
wbeard52's user avatar
  • 3,445
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 ...
Martin Liversage's user avatar
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 ...
Felix Dombek's user avatar
  • 2,063
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) ...
user avatar
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 ...
Mestika's user avatar
  • 971
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 ...
XuMuK's user avatar
  • 300
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 ...
stevemidgley's user avatar
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 ...
zumalifeguard's user avatar
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) ...
Real Dreams's user avatar
  • 4,952
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 ...
XP1's user avatar
  • 1,041
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 ...
attenzi0ne's user avatar
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 ...
Sam's user avatar
  • 312
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 !
user avatar
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/...
Andrew J. Brehm's user avatar
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 ...
zundarz's user avatar
  • 1,163