Questions tagged [date-time]
The date-time tag has no usage guidance.
523
questions
0
votes
0
answers
20
views
Thunderbird: How can I customize the date/time format in the message header?
How can I customize the date/time format in Thunderbird's message header section (see screenshot) ?
I would like the format to be: Thu, 13 Jun 2024 22:34 UTC+1
The answer should work for the current ...
- 261
1
vote
1
answer
196
views
Firefox uses UTC time instead of UTC+2
all of a sudden, TV program schedules were shifted by (-2) hours. Here are some relevant details on this problem:
1. Linux Console
~$ timedatectl
Local time: sam. 2024-05-04 12:41:03 ...
- 177
0
votes
0
answers
209
views
Can't sync time on Windows 10 due to w32tm access denied
tl;dr: I cannot sync time on Windows 10, because w32tm /resync responds with Access denied. The strangest (to me) part is that I can run w32tm in combination with any other switch. It says about no ...
- 11.4k
0
votes
0
answers
39
views
Excel transforming dates ddmmyy to yymmdd
Having a date issue. When I enter date in excel as folles today being 20-04-24 , excel transforme it into 2020-04-24 . So it's mistaking the day for the year.
0
votes
3
answers
626
views
How do I get the sum of hours:minutes in MS Excel in the status bar and in a formula if the cells come in with a text format?
I know that there are questions around that are much the same, like Sum the number of hours in Excel, which asks you to format [h]:mm, which I do and it still does not work.
Also not so far is How do '...
- 2,431
1
vote
1
answer
138
views
IN VBA, How to sum hours and minutes exceeding 24 in memory (not in ranges of excel)
I'm getting some data in the format of text(like for example "12:47" that means 12 hours and 47 minutes) from a URL document and calculating some parameters like overtime work, shortages and ...
0
votes
0
answers
24
views
when does windows 10 check to automatically set the time? [duplicate]
I have the same issue as described in this question. I have a dual boot with windows 10 and ubuntu and every time I start up windows after having used ubuntu, the displayed time is wrong. This is ...
- 101
0
votes
1
answer
206
views
MacBook Pro M3 date time in macOS Sonoma (14.2.1) all messed up after battery went to dead, how to fix automatic time?
My MacBook Pro M3 battery died on Friday Jan 19, 2024. The system is running macOS Sonoma (14.2.1). Then here's what happened:
Opened computer today on Monday Jan 22 around 9am.
Date time said Friday ...
- 387
1
vote
1
answer
642
views
How long the URL of a YouTube video last before expiring?
On executing youtube-dl -g <youtube_link> we get the urls for the video and the audio, we can play those urls with vlc for example.
But for how long those urls are valid?, they're of the form:
...
- 129
0
votes
2
answers
136
views
Excel datetime format issue, possibly locale dependent
I'm working on a Belgian Excel 365 workbook. I have just imported a list of dates, looking like this:
dinsdag 5 december 2023 11:55:55
dinsdag 5 december 2023 11:55:56
dinsdag 5 december 2023 11:55:57
...
- 2,281
0
votes
0
answers
54
views
Why does echo $(TZ=GMT+17 date +%Y%m%d%H%M%S) show me yesterday?
When I run this command today, November 8, 2023 at 1100 GMT, the output is: 20231107180000:
echo $(TZ=GMT+17 date +%Y%m%d%H%M%S)
I would have thought that, if anything, GMT+17 would ADD 17 hours to ...
- 1
0
votes
1
answer
522
views
How do I create an Excel pie chart representing a simple 12-hour clock?
I want to create a pie chart in Excel that represents a hand clock so that I can mark different time periods with different colors
2
votes
1
answer
887
views
FFmpeg - write video segments with filenames containing timezone offset
I need to write an FFmpeg command that records a stream in segments of x seconds. The segments should be named using the UTC date and time (UTC+0), rather than my local PC time. Alternatively, I'm ...
- 23
1
vote
1
answer
211
views
RFC-3339 Date and Time in Mozilla Thunderbird 102 (YYYY-MM-DD HH:mm:SS Z)
How can I configure Mozilla Thunderbird to format date and time of mails like
YYYY-MM-DD HH:mm:SS Z
2023-08-13 19:10:08 +2:00
this is one of the RFC-3339 representations.
- 1,122
26
votes
2
answers
5k
views
What is this 14-digit time format from Windows registry?
Microsoft Office 365 saves information in the registry about what time it last searched/downloaded/applied updates in a format like this:
Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\office\ClickToRun\...
- 8,357
0
votes
0
answers
623
views
PC under 2019 domain controller change the time by svchost
I have a domain controller Windows 2019.
This domain is in Egypt, and as you know, the daylight feature has been activated this year.
I updated the domain so that the time zone can be changed without ...
2
votes
1
answer
85
views
How to parse /var/log/pm-suspend.log date to calculate time difference?
Date format in /var/log/pm-suspend.log is like Wed 05 Jul 2023 04:55:30 PM +03, which I think is in date +"%a %d %b %Y %I:%m:%S %p %z" format.
How can I convert this date to Unix timestamp ...
- 635
0
votes
1
answer
134
views
Suspend/Resume restarts the machine (GNOME)
2023-05-19 GNOME "Power Off/Log Out -> Suspend" restarted the machine three times in a row. I was trying to suspend the machine from the lock screen (before logging in). Usually this ...
1
vote
1
answer
124
views
how to test in bash which of the two symlinks is older (or newer)
Apparently, the bash tests -nt and -ot dereference links.
Let's consider the following files and links to them:
$ ls -lt --full-time f* | cut -d ' ' -f 6-
2023-04-24 02:05:01.083919712 +0200 f1l -> ...
user1787659
1
vote
2
answers
2k
views
Manually Set the Date and Time on a Chromebook (ChromeOS 111)
I have a 13" Lenovo Flex 5 (2022) Chromebook, running ChromeOS 111 and I need to be able to manually set the date and time. From internet searches, I found that I should be able to use the ...
- 185
1
vote
1
answer
71
views
How to set old modification times between the working directory and its backup recursively?
Let's assume you have two directories, e.g., /long_path_1 and /long_path_2 (potentially with spaces), that you know to be almost equal, e.g., because you previously ran diff -rq --no-dereferences /...
user1787659
2
votes
1
answer
198
views
Windows 11 changed Finnish date format to not include weekday, now my batch scripts won't work
I have this script that relies on getting the current day of the week from the command line..
if "%date:~0,2%"=="ma" set "weekday=true" & set "hangday=false"...
- 313
-1
votes
2
answers
150
views
How do i convert a date, stored as text with time, as "DD/MM/YYYY"
Please can you help, I have a report, with a fixed output of "Dec 15 2022 17:00:00" as the date for each line of date; however, I need to add a column to change this data to "DD/MM/YYYY&...
1
vote
2
answers
168
views
How to write custom time format in Microsoft Excel?
I'm trying to make a format which can convert values like 48.37 to 48h 37m.
- 121
1
vote
1
answer
542
views
Date format issue
I export some files from a network as CSV and then I convert that file as excel file there is one column in excel file named-as (dates) now when I apply the filter on it the filter is not slowing ...
- 11
0
votes
1
answer
1k
views
SUMIF all times between a start and end time of each day
I have an interesting one which I am really struggling to resolve and feel this should be possible using SUMIFS somehow!
I have the following (as per the image):
I have a number of tasks to complete ...
- 3
2
votes
1
answer
4k
views
PowerShell script to automatically adjust system date/time
I'm looking for something very specific. I've been searching it for weeks on and off whenever I have the time and now I just few like I'm wasting time because I can't find anything, so I guess the ...
- 23
0
votes
1
answer
270
views
Subtracting times in Excel inconsistently shows pound signs or 0:00:00 when duration is 0 seconds. How do you prevent pound signs?
I have an excel spreadsheet with a Start Time and End Time column. I'm trying to add a "Duration" column which obviously subtracts the Start Time from the End Time.
In some instances the ...
- 402
0
votes
0
answers
2k
views
How to copy files in File Explorer while preserving all Metadata attributes: Including Last Accessed Date, Modified Date, etc
I have scoured superuser for an answer, and have found similar questions, but none of them talk about preserving the Last Accessed Date. I have already wanted to archive all the last accessed dates on ...
2
votes
0
answers
2k
views
Unable to set time zone in Windows 11
So, I'm running into what seems to be a common problem, but I can't believe the answers I have found so far are the only right ones.
I'm running Windows 11 home, logged in as the administrator account....
- 21
1
vote
2
answers
550
views
How to convert characters to hour type and add?
I have the following list:
[string]$list = ('06:33','07:29','11:54')
How do I convert it to numeric type and add?:
output expected:
25:56
- 271
0
votes
0
answers
41
views
Data Source to Excel Date
I've been trying to import data from excel to google sheet. The data I got was in the format of dd/mm/yyyy, which makes sense as we use it in where I live; however, once I tried to copy paste the data ...
1
vote
0
answers
239
views
Didiving axis by months for XY scatter chart in Excel
I have the data plotted on a yearly basis, which requires the division between full months.
Unfortunately, it seems like this option is not possible in the XY scatter chart, because the Axis type ...
- 133
0
votes
0
answers
504
views
nftables or fw4 issue with timebased traffic rules
Since the OpenWRT ver > 22.3 does use NFTABLES instead of IPTABLES
I got issue with some firewall (fw4) time based traffic rules that I
have no idea how to solve them.
The firewall rule is as ...
- 1
0
votes
0
answers
616
views
hwclock synchronization failed
After suspend/resume the system time is wrong (Set system time after Suspend) Not giving up. It was alluded (in answers) that it might be connected with the CMOS clock malfunction. Tried to ...
0
votes
0
answers
51
views
Excel - instant conversion from text data value to real data value
I have a set of dates stored as the text value (cells formatted as "General"), which are i.e. 12.11, 10.11, 30.05, 1.06 etc.
Now I want to produce the chart with these values, but it ...
- 133
1
vote
0
answers
2k
views
Windows clock keeps falling behind, even after CMOS change
The clock on my computer keeps falling behind and the only way to correct it is by pressing 'Sync' in the Date/Time settings. I have changed the CMOS battery to a brand new one but the problem ...
- 291
0
votes
1
answer
526
views
Excel =NOW() displaying date serial number, instead of date/time, in =HYPERLINK to generate email
I have a =HYPERLINK() formula in Excel to generate an email, based on the contents of cells for "To:", "Subject:", and "Body:" fields.
Subject: cell that contains =NOW() ...
- 3
0
votes
0
answers
128
views
How to Sync My Windows Server time to user
We are using a Windows Server 2012 R2 in our Company, and we have active directory with 100+ users. but we are facing a issue, When our user restart their computers, their computers aren't syncing ...
2
votes
1
answer
2k
views
In PowerShell, how to save a DateTime variable into a file to be retrieved later?
I want to log the timestamp when a certain line is executed so that the script can know how long it has passed since last execution of that line, even if the script is stopped in between and the ...
- 192
1
vote
0
answers
540
views
Why does my Windows clock keep going out of time?
My clock doesn't stay synced. I can sync via settings and it works for a bit but then it goes out again after a while.
Auto-sync with time server is selected.
I have tried restarting the Windows Time ...
- 399
0
votes
1
answer
113
views
Update (incorrect) timestaps of copied files with original date from the source file
I copied a rather large folder using Ubuntu (in the magnitude of a few million files, and a couple of terabytes, so synchronizing takes about today). I forgot to set a switch so the copying process ...
- 10.8k
1
vote
2
answers
902
views
date reverts to current date after changing it
I have a VirtualBox VM running an x86_64 Ubuntu 22.04. Whenever i try changing the date to a previous date (in my case 5 days ago), the date always reverts back to the current date a few seconds later....
- 184
1
vote
0
answers
50
views
Landline on NBN reverts phone's +8 WA, AU time to UTC time on any incoming call
I have a very, very strange issue to report and I have zero idea why it's happening. I can't even be sure if it's NBN-related or what could be causing this.
An older lady friend has NBN FTTP. She has ...
- 11
4
votes
3
answers
32k
views
WIndows 10 time zone keeps reverting back
I've got a user whose Windows 10 computer won't hold the correct time zone. Specifically, the time zone randomly changes back. The user is in Pacific Time, but the laptop would have been set up at a ...
- 65
0
votes
2
answers
622
views
How to add Epi Week aka MMWR Week column in Power BI
My dataset has a date column. I need to assign the correct Epi Week/MMWR Week to each row. I can't do it by hand because the dataset spans five years and has over 18,000 rows.
The Power Query function ...
- 307
0
votes
1
answer
1k
views
Removing date from datetime (VBA Excel)
I need to delete the date from mulitple rows with a datetime value. Or extract the time to another cell.
For example:
A1 = 3/11/2022 10:20:00
A1 after macro = 10:20:00
or
A1 = 3/11/2022 10:20:00
A2 = ...
- 1
-1
votes
1
answer
337
views
Better understanding 2FA
Why does 2FA fail unless geo-location is enabled system wide ?
Solutions offered ( https://debiankalilinuxtips.substack.com/p/automatic-datetime-sync ) for date/time sync do not resolve 2fa requiring ...
- 3
1
vote
0
answers
1k
views
How can I create a 24-hour time period "occupancy" chart in Excel?
(First time posting, long time lurking, thanks!)
I'm trying to create a time series of site 'occupancy' - Basically, how many people are logged into the site over a given time period. Along the x-axis ...
- 11
0
votes
1
answer
610
views
Increase time by 15 minutes by 4 rows per 'time slot'
I'm trying to create a list of certain times for people to sign up in a form.
I did the following by hand, but I'd like to use a formula for it. Looked over the internet for iteration formulas for ...
- 143