Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
45 views

in code better time format strategy. milliseconds or concat time string?

Which of these should I choose for time formatting? 1. Wednesday, June 3, 2020 11:34:10 PM GMT-04:00 2. 1591241594000 what answer should have I provided? I was guessing 2. but is there a ...
1
vote
2answers
45 views

How do the major OS like Windows, Mac and Ubuntu/Redhat handle DST and time that goes back 1+ hour?

When time is out of sync, I understand most of the modern operating systems have NTP software that do it in smart increments spreading it through a large interval such that it doesn't affect most ...
0
votes
0answers
29 views

In Linux how can I show ALL dates and time in ISO-8601 format?

In Linux how can I show ALL dates and time in ISO-8601 format? It used to be possible to edit /etc/default/locale and just add ISO-8601 there but that does not seem to work anymore.
-1
votes
0answers
17 views

Powerquery Excel - DateTime format issue

We are fetching data from ODATA using Powerquery. Through we set column type as Date/Time, after every refresh, datetime format is getting changed. maximum records are showing correctly however lots ...
0
votes
1answer
32 views

How should this datetime format be interpreted? “20190328012019.000000+120”

20190328012019.000000+120 That's the weird timestamp outputted by WMIC commands on Windows. I assume that 2019 is the year, 03 is the month and 28 is the day, and that 01 is the hour, 20 the minute ...
0
votes
2answers
22 views

Changing Windows time format from displaying “.” to “:”

Very tedious question, but I simply can't stand the format. I'd like to change the way time is displayed from eg. 11.26 to 11:26 I can't seem to do this anywhere within the Windows 10 settings, I've ...
0
votes
0answers
24 views

Have multiple calendars in Win10

I have enabled Solar Hijri calendar in date & time settings on my Windows 10 PC. Is there any tool or trick to enable Gregorian as a second calendar and have multiple calendars at once? (Just like ...
1
vote
2answers
117 views

Has anyone seen the output of the “net time” command display odd characters?

I've started seeing this on numerous Windows 10 systems, including my work and home PCs. Essentially, the time output of the NET TIME \\LOCALHOST command, which usually looks like "Current time at \\...
0
votes
6answers
235 views

Excel date convert from Mar-29 to 29/03/2020

Simple question that I have not been able to find an answer to. I have some data that doesn't have years and is formatted as Mar-29, as I have pasted into Excel, but Excel converts this into data ...
0
votes
0answers
19 views

Disable internet sync time and date Windows 10 pro

Please advice i try too much to disable internet sync time & date windows 10 pro I did the following: I choose set time and zone manually i stop automatically sync time. I stop windows update ...
0
votes
1answer
58 views

How to retain date format from raw csv file as is when opened via MS-office Excel?

I have data given to us via email/hard drive which has randomized future dates (ex: 21/02/2200) in multiple formats. During data transfer 1st mail, the file sent has date format in DD/MM/YYYY. ...
4
votes
2answers
165 views

Why does Excel get another result than PowerShell and Google when trying to find out how many days have passed since 01.01.1900?

A colleague told me: "Excactly 43871 days have passed since 01.01.1900". Today is 10.02.2020. I wanted to check that with PowerShell, but I got another result: PS C:\Windows\system32> New-...
2
votes
1answer
126 views

How to freeze the date in Windows 7 or disable it

I want to set the date on my windows 7 Home Premium virtual machine to Jan X, 2009 (any day in that month). Or if I cannot do that set the date to Jan X, 2009 and then let it increment normally after ...
0
votes
0answers
13 views

How to copy selected files to a destination named with today date? [duplicate]

Actually in my work i have a files i received every day in shared works folder and i must keep them in a local folder in my pc and been categorized in a folders named by the date. i want to add an ...
1
vote
0answers
58 views

how to install deepfreeze after force defreeze

i installed deepfreeze on windows 10 pro. i promptly forgot the password. prehaps i should have done something else. out of desparation is booted into the bios and set to clock to three months from ...
1
vote
2answers
71 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 ...
1
vote
2answers
36 views

Format cell as days plus time duration

In Excel I have cells that contain durations, stored as date (integer part) plus time (fraction) as usual. Now I would like to format the values to see the number of elapsed days plus the remaining ...
0
votes
1answer
141 views

Excel Graph - How can I graph time-series data with uneven measurement in format (other than x-y scatter)?

I'm trying to chart some vital sign measurements but don't want to use an x-y scatter... my issue is that the measurements were not taken at even intervals (not even close) and were taken multiple ...
0
votes
0answers
20 views

win7 cannot change date and time: How to fix

I cannot change Windows 7 date and time (not programmatically). A few months ago I used this https://www.thewindowsclub.com/prevent-users-changing-date-time-windows-10 on my Windows 7 computer to ...
2
votes
1answer
65 views

bat file to change date time of files in a folder with today date time reading the file name from a text list

I have a folder with a large number of files, these file will be periodically deleted using date time (old will be removed automatically). I need to keep some files inside this folder and prevent ...
1
vote
0answers
23 views

Excel uses custom date format in new workbooks for newly entered dates

I am using Excel 2010 on a US windows 7 machine. I made a new default macro enabled template for Excel to use for all new workbooks. When I make a new blank workbook and enter a partial date like 8/13 ...
2
votes
2answers
472 views

No solution for Thunderbird date format

I run Linux Mint 19.2 and Thunderbird 60.8.0 (July 2019). I am trying to change the UI to display the dates in a reasonable date format called ISO 8601, and for that I tried setting LC_TIME=en_DK.UTF-...
0
votes
1answer
911 views

How do i remove date from a date and time from an excel cell

I have a very huge sheet with date and time values. I am exporting the calendar start date and end date into excel from outlook. I just want the time value in the field. Upon searching i found an ...
2
votes
0answers
135 views

Excel Line chart X-axis does not display the right date/time

I am trying to plot a line chart in Excel , the x-axis is changing the year value significantly and I cannot figure out why. It is taking my data from 2017 and adding over 100 years to it. For the ...
0
votes
1answer
38 views

converting time in excel and/or adding +12 hours

I have this time in excel 2019-08-04T06:48:45.000Z It is in GMT time, how do I convert it to +12 hours? So what I want is 2019-08-04T18:48:45.000Z. That's an easier one(just have to change the hour) ...
0
votes
1answer
30 views

Excel 2013 showing only certain dates in a European format

I have a CSV file where all dates are in a U.S. format (dd/mm/yyyy): However, Excel shows some - but not all - of the cells in mm.dd.yyyy format: This is on a server in Germany. Does anyone know ...
0
votes
0answers
29 views

How did my laptop go back in time briefly?

I was running a script last night that uses timestamps to keep certain things in check. The script had stopped executing when I woke up this morning, and I dipped into the logs to take a look as to ...
0
votes
2answers
43 views

date without dashes and colons ms access + can date be part of autonumber?

I want the date (22-12-2018) without dashes and colons in Ms Access for a field. How can I achieve it? Also is there some way to change the alignment i.e. (22-12-2018) should be 22122018 or 12222018 ...
-1
votes
1answer
43 views

How to sum and display time in day-hr-min format

Lets say I want to display O9 in day-hr-min format by adding 08 to I9,J9,K9
0
votes
0answers
1k views

How to batch change file creation date to file modified date on Windows?

I have a lot of files which have their timestamps messed up. Particularly, file modified timestamp reflects the date the files were actually created, but the file creation timestamp reflects some ...
9
votes
3answers
2k 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 ...
0
votes
1answer
619 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
vote
1answer
237 views

Determine number of non-Sundays in a part of a month

Calculate number of Sundays in the month asks how many Sundays there are to the end of the month.  Two users proposed very similar answers that I liked and worked very well to determine how many ...
1
vote
1answer
140 views

Centos is giving wrong date time for all the dates below the year 1905 from NodeJS

I'm having a weird situation. Recently I've moved from Azure cloud to Digital Ocean server. I'm using Nodejs version v10.15.0 and Centos 7. My timedatectl output is [deploy@prod-ca-api install-...
0
votes
1answer
68 views

File last modified time same as download provider

When I download a file the creation and last modified date & time are set to the download time. Is there a possibility to restore the creation / modify date & time of the old owner?
22
votes
2answers
3k 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 ...
1
vote
4answers
2k views

What's the quickest way to copy the current date and time to clipboard?

I want to paste the current date and time to a spreadsheet and I am using the NOW() function and copy from there and paste as string but there might be a faster way. There might be an excel solution ...
1
vote
1answer
120 views

How does notepad.exe obtain the current system date format

I was trying to find out how Notepad.exe is able to get the current system date format saved in the Windows registry without appearing to access the registry. I added a filter on the HKCU\Control ...
0
votes
1answer
1k views

Why is Windows 10 showing wrong file media create date?

Totally stumped on this. Copied some mp4 files off my phone, that I need to show a correct date for. Checked the file properties and found an empty "media created" date field. The date should've read ...
0
votes
2answers
84 views

MS Excel - How to read DATE from text generated with different locale

I'm writing this question after reading How to use DATEVALUE with diffent locale setting without changing system settings didn't solve my problem. It's about reading the correct month from a text ...
-2
votes
2answers
185 views

Converting time string text to hours and minutes in Excel

I have a time string in a text-formatted cell that looks like this: "102:16:47.04". How can I convert it to time string like this: "102:16" ?
2
votes
3answers
302 views

In Chrome how I can see a webpage's time/date info?

In IE I can right-click, select Properties and see the page's date (but not time). I don't see any similar feature in Chrome. And how about Firefox.
0
votes
1answer
49 views

Setting a variable based on the time of day

I cannot seem to get the if %day% EQU lines correct. I am trying to get the autoShutDown variable to "T" when the script is run between Friday night 8:30 PM and Saturday at 5:15 PM. But it seems like ...
0
votes
0answers
77 views

Windows 10 System Time Update Not Working

My Windows 10 desktop is not able to update its system clock from internet time servers. At least, I don't think it can...although the time it's displaying seems roughly accurate (within a few minutes)...
0
votes
1answer
65 views

Excel - Tracking time +/- between sequence of dates

I am making a scheduled events in Excel 2016 that tracks the difference between a series of date/time stamps and keeps a running total. ... | ETA | ATA | Diff | ...
1
vote
3answers
3k views

Excel =TIME() with values over 24 hours displays incorrectly

I'm trying to display times over 24 hours in Excel by using =TIME() but when the values get over 24 hours they display incorrectly. For example I have =TIME(27;42,81;49) which should be displaying 24:...
0
votes
1answer
81 views

Excel Formula : Find out time spent in specific time ranges

Trying to work out a slightly more complex overtime worksheet here: Employee gets paid: 1x hourly rate during weekdays (Mon-Fri) during 08:30 to 17:30 1.5x hourly rate during weekdays (Mon-Fri) ...
2
votes
1answer
256 views

Computer date/time lagging behind

A work colleague's computer is having an unusual problem. Whenever the computer is restarted the time and gets set to approximately 1.5 days previous. The timezone is set correctly, but the computer ...
0
votes
2answers
125 views

Subtract DateTime in this format

C2 = Start date = 9/16/2018 12:41:02 B2 = End date = 9/18/2018 15:37:12 Using 24 hour format Tried using =TIMEVALUE(RIGHT(C2,8))-TIMEVALUE(RIGHT(B2,8)), it wouldn't work when the result supposed to ...
0
votes
0answers
24 views

System clock resetting, making conflicts with write stamps

My system clock is resetting to a date back in 2016 for some reason and as a work around I reset the date manually every time I boot it. Whenever I boot into Arch with a auto-resetted system date(i.e ...

1
2 3 4 5
9