Questions tagged [date-time]
The date-time tag has no usage guidance.
518
questions
0
votes
1
answer
43
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
23
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 ...
0
votes
1
answer
122
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 ...
1
vote
1
answer
249
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:
...
0
votes
2
answers
90
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
...
0
votes
0
answers
34
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 ...
0
votes
1
answer
302
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
548
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 ...
0
votes
1
answer
145
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.
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\...
0
votes
0
answers
432
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
79
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 ...
0
votes
1
answer
111
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
112
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 -> ...
1
vote
0
answers
783
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 ...
1
vote
1
answer
70
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 /...
2
votes
1
answer
162
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"...
-1
votes
2
answers
131
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
146
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.
1
vote
1
answer
471
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 ...
0
votes
1
answer
790
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 ...
2
votes
1
answer
3k
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 ...
0
votes
1
answer
228
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 ...
0
votes
0
answers
1k
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
1k
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....
1
vote
2
answers
456
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
0
votes
0
answers
31
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
210
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 ...
0
votes
0
answers
445
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 ...
0
votes
0
answers
549
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
43
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 ...
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 ...
0
votes
1
answer
473
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() ...
0
votes
0
answers
110
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 ...
1
vote
0
answers
363
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 ...
0
votes
1
answer
106
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 ...
1
vote
2
answers
767
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....
1
vote
0
answers
42
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 ...
4
votes
3
answers
23k
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 ...
0
votes
2
answers
563
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 ...
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
votes
1
answer
245
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 ...
1
vote
0
answers
946
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 ...
0
votes
1
answer
563
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 ...
6
votes
2
answers
17k
views
How do you set the Google chrome date format to yyyy-mm-dd hh:mm:ss?
My system datetime format is set to ISO 8601, but since I am using British English in Chrome, Chome is insisting I use dd/mm/yyyy. How do I switch to the correct format?
0
votes
1
answer
496
views
Excel VBA - Dealing with Overlapping Times
I have a really big table in Excel that has multiple rows where each row contains a comparison between two employees that had worked over the same time. See examples of some sample rows in the image ...
0
votes
1
answer
150
views
Recognize datetime in 20211124_1502 format with Excel
I have a column in an Excel table with datetimes in this format:
20211124_1502
I tried different formatting options for these cells (Date, Short date, etc.) but the date is never recognized/parsed (...
0
votes
1
answer
1k
views
Grouping overlapping times in MS Excel
I have a spreadsheet that contains multiple entries each with a start and end time. I want to be able to identify overlapping time entries and then be able to group the overlapping entries by perhaps ...
0
votes
1
answer
2k
views
Excel Date Timezone Conversion [duplicate]
I have a spreadsheet from a system that outputs the date and time format like this:
15/09/2021 04:29 AM
The format of the field/cell is Custom:
dd/mm/yyyy hh:mm
How do I convert the output so that ...