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 ...
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 ...
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?
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 ...
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 ...
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 : `=...
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 ...
3
votes
2answers
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
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, ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
6
votes
3answers
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
3answers
1k 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'...
3
votes
1answer
3k 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 ...
1
vote
1answer
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
3answers
5k 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
2answers
37k 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
votes
2answers
3k 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 ...
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 ...
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?
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-...
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)?
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 ...
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 ...
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 ...
5
votes
2answers
9k views

How to insert date/time in notepad++ 64bit

Old question are about 32 bit. And they are working on 32 bit. But in 64bit notepad++ there are much less working addons, so the most fastest solution: open simple notepad, press F5 and copy date-...
4
votes
8answers
31k 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) ...
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 ...
2
votes
2answers
5k 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 ...
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 ...
5
votes
4answers
34k 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 ...
4
votes
2answers
44k 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
1answer
2k 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
1answer
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
1answer
3k 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 ...
2
votes
2answers
36k views

Calculating a duration in excel from date and time

I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be ...
2
votes
2answers
370 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
2answers
3k views

Date format worldwide in Excel

On a Mac Mountain Lion, US locales, I'm working on a Spreadsheet with macros like TEXT(TODAY(), "yyyy-mm-dd")&" is the date" The problem is that the sheet is also used on computers set with ...
0
votes
1answer
423 views

How does Excel handle the h:mm:ss format?

I have the number 0.00082788917980126 which once converted to h:mm:ss format gives me 0:01:12, and I need to understand how as I need to perform similar formatting outside Excel, hence my question: ...
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 ...
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 ...
4
votes
2answers
2k 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 ...
2
votes
1answer
32k 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 !