Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
25 views

Windows time off by 1 hour when placing orders, making appointments, etc. on ecommerce sites

In three instances, appointments made with local businesses have been off by 1 hour. Two of those instances were scheduled pick-up times at a local pizza restaurant. Twice, we showed up 1 hour before ...
-1
votes
0answers
29 views

How can I expand timestamp into rows and columns?

I have a spreadsheet that looks like that I need to make each day a column and each row a minute of the day ranging from 00:00 to 23:59 This is a sample of the I extracted time and date and made a ...
8
votes
3answers
941 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 ...
0
votes
1answer
29 views

Can't sync time on Windows 10

I can't sync time and the Windows Time Service isn't showing on services.msc Already tried: Tweaking repair software. Register the W32Time file but the Windows Time service doesn't show up yet. w32tm /...
0
votes
2answers
50 views

Chart based on dates

I created a dashboard for my work program tracking. I am trying to create a chart based on the dates so I can easily see how many people have done their competency. I have conditional formatting for ...
1
vote
1answer
98 views

Windows 10 - Internet Time Sync Error - Time Out

I have Airtel (ISP) Broadband at home. Same ISP is also my Mobile Network provider. I have DIR 615 router connected to Airtel Broadband, Windows 10 desktop and laptop. When I am on Airtel Broadband ...
0
votes
2answers
45 views

sorting dates and time (in text form) in Excel

My date and time entries in my excel file are written in the form of: Feb 18 at 3:50pm. All of this is in one cell. I was wondering if there is a way to sort this out (arrange chronologically)
1
vote
2answers
34 views

Excel won't recognize timestamp in format of “m/d/yyyy h:mm:ss AM/PM”

I have a column of timestamps (strings) formatted like so: This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM I'm trying to get them to be formatted into dates but Excel refuses for ...
0
votes
0answers
36 views

How To Add Seconds To Date/Time Format of Prime95 Logging?

Prime95's default log format is MMM dd hh:mm e.g. Feb 26 07:16. I am using Thread Switcher for stability testing which works well switching every 5 seconds. I've had to increase this to 120 seconds in ...
1
vote
0answers
17 views

Debian: Set persistent custom time

I try to set a custom time on my (fresh installed) Debian system. For example, I want to set my time to 2013-05-05. So I disabled NTP on my system with timedatectl set-ntp false, verify that ...
0
votes
0answers
30 views

Excel automatically assumes a date+time format and when choosing text format it generates an unrelated number

How can I format a cell in Excel to show time and date, with milliseconds, I have tried using : (jjjj-mm-dd hh:mm:ss.000) Here's the raw CSV: 2021-02-11 17:32:43.177 2021-02-11 17:32:43.912 2021-02-...
0
votes
0answers
29 views

Why does Windows 10 show the wrong time on the system clock after a reboot?

I'm running Windows 10 on my PC. I have Windows 10 configured to sync to a remote clock. However, every time I reboot my PC, the clock jumps ahead about 45 minutes and continues to display the wrong ...
0
votes
1answer
16 views

Is there any way to reverse the time to the time before the webpage close the fill out form? If the webpage track the local timezone

Is there any way to reverse the time to the time before the webpage close the fill out form? If the webpage track the local timezone.
0
votes
2answers
34 views

Can I display Windows toolbar date in ISO 8601 format?

I want the date in my Windows toolbar to display in ISO 8601 format. Is this possible? If so, how? For example, the date currently appears in the toolbar like this: 1:43 PM 2/3/2021 I want it to ...
0
votes
0answers
13 views

Excel aggregate into timetable

I need to aggregate data from a flat table into a timetable. The table contains: date time start time end resources 2021-01-29 12:15 13:15 200 2021-01-29 12:45 13:45 200 How could I aggregate the ...
0
votes
0answers
18 views

Setting the file modified time to show seconds in Explorer [duplicate]

Does anyone know how to set Windows Explorer Details View to allow the file modified time to show the number of seconds? This used to work in old Win XP. Since the wizards at MS seemed to have removed ...
0
votes
1answer
16 views

Display (or get at least) certain cell last modification date in Excel 2003 file (file extension is *.xls)

I have some Excel table which I filled with values since 2004. To sad I didn't include each row add date in extra cell. Now I want to know that... Maybe it still possible? Maybe *.xls file store that ...
3
votes
0answers
51 views

.bat file: execute command if file modified after main command was started

I have a .bat file executing several commands: Compiling a document with pdflatex and externalizing the tikzpicture creation into .pdf files if some modifications were made since last compilation ...
0
votes
1answer
24 views

Is thеrе any wаy tо propеrly displаy nеgativе timе spаns in Exсеl?

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 ...
0
votes
3answers
121 views

Getting the wrong result subtracting a Date&Time from another Date&Time in Excel

I am trying to subtract a date/time in cell Format Custom: mm/dd/yyyy hh:mm:ss AM/PM. from another time in the same format. I have tried ideas from so many websites as to how to do it but none show an ...
0
votes
0answers
16 views

Windows 10: How to correctly setup time sync with remote time server?

I have one of those old laptops who's hardware/BIOS clock doesn't work, it resets to 2010-01-01 upon each reboot. But I still want to use this laptop because everything else works perfectly fine apart ...
0
votes
0answers
12 views

Date modified is not being shown for any kind of extension files

Time stamp is missing and date modified is not being shown for any kind ox extension files. Iam on Windows 7 professional. Date modified is not being shown for any kind of extension files.
0
votes
0answers
73 views

How to convert dated time to fraction hour format

I have the following format of time data imported from a software (in the lefft section). I need them in hours (fraction) for representation (like the example in the right side). How am I supposed to ...
0
votes
0answers
22 views

Windows 10 - Time Sync Issue After Sign Out

I am running into a weird issue on Windows 10 1909 for a computer on a Domain environment over VPN when signing out of windows. When we use the computer's "Sign Out" feature and leave it ...
0
votes
0answers
14 views

Stamp numbers in different cells in Excel

I have a column with different ID number in each cell. I need to stamp each of this number with the same date (20160608) and a separation _ (underline) between ID number and that date (for example, ...
0
votes
0answers
35 views

Calculating full time difference taking time zone into account and including the fractional parts of a second?

Let's assume you have full times (with dates, time zone, and fractional parts of a second) coming from ls -la --full-time listings: screenshot How do you calculate the durations in seconds including ...
2
votes
2answers
30 views

Bash: Date/Time math problems

The following script takes two inputs, sourceFile="${1}" and trimFile="${2}". The $sourceFile is a video file that is to be trimmed into multiple new files based on data in the $...
0
votes
0answers
7 views

Debian Buster on Pine64: Log rotation kills systemd-udevd and offsets datetime?

Running a Pine64 with HomeAssistant and Domoticz for home automation and monitoring. At night, when log-rotation is called, some strange things happen: Sep 26 00:00:26 localhost systemd[1]: Starting ...
0
votes
1answer
48 views

Calendar in date and time is always in lock state in Mac , how to unlock for always and used it like windows calender

Calendar in date and time is always in lock state in Mac , how to unlock and used it like windows calendar Currently I need to unlock it each time to access calendar the main intention here is to ...
0
votes
1answer
67 views

Date Calculation

I have a Date range, 2020-11-25 as Start Date 2020-12-10 as End date I wanted to get the count of December month days in the above Date range if I am looking for December month.(I need the output as ...
1
vote
1answer
273 views

How to extract date from filename on Windows [closed]

I need to do hand formatting date values for some files. I have just extracted 6000 photos/videos from an application and they are all named following this structure, with different dates and times ...
0
votes
1answer
80 views

Different serial numbers behind the same time value in Excel

I have a number of 10-minute interval time series CSV files. Sometimes there are single rows missing in the files. To complete the missing rows, I decided to search for them in Excel and insert new ...
0
votes
1answer
971 views

MS Regedit Hex to Date Conversion

I'm trying to analyze my redundant network profiles on Win 10 via registry path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\Profiles However, I'm unable to interpret ...
0
votes
0answers
25 views

4k monitor will only display 3-row date in taskbar when using 100% scaling and set as the main monitor

I am using a 4k external monitor over usb-c to DP alongside a 4k laptop. I prefer to use the external monitor as the main one since it's larger. The issue is that when using it as the primary monitor ...
0
votes
0answers
19 views

Why I can't change the time format of a Standard user account

In simple words we have Desktop computer with windows 7. I'm Administrator user and my wife and my daughter are standard users. So while explaining to my daughter I just looked for time in ...
1
vote
2answers
38 views

Rationale behind Date created, Date modified` & `Date` on Windows 10

I am trying to understand the rationale behind Date created, Date modified & Date on Windows 10 File Explorer. Yesterday, 30th June 2020 I downloaded a Youtube video and its subtitles in these two ...
1
vote
1answer
483 views

Excel: total of time difference formatted in months, days, hours, minutes and seconds

I need an Excel Ninja. I want to format a cell in Excel so the total time difference is formatted in months, days, hours, minutes, and seconds. Right now, I don't know how to add "months" ...
-1
votes
2answers
39 views

How To Sort Time Data, to only showing exact clock (hh/mm/ss)? [closed]

i want to sort my time data (there's a lot of it), to only showing data that only show the exact clock in hh/mm/ss format, so i can delete the unnecessary data. for example, from : to only showing ...
-2
votes
1answer
52 views

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

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
49 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
59 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.
0
votes
1answer
38 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
28 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 ...
1
vote
2answers
241 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
703 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
1answer
672 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
215 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
483 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 ...
1
vote
0answers
111 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 ...
2
votes
2answers
3k 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
2 3 4 5
10