Questions tagged [date-time]
The date-time tag has no usage guidance.
513
questions
0
votes
0
answers
27
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
150
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
145
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
0
votes
1
answer
87
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,082
26
votes
2
answers
4k
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\...
- 6,110
0
votes
0
answers
205
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
71
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 ...
- 595
0
votes
1
answer
80
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
96
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 -> ...
- 133
0
votes
0
answers
436
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 ...
- 223
1
vote
1
answer
65
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 /...
- 133
2
votes
1
answer
113
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"...
- 209
0
votes
2
answers
112
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
99
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
278
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
400
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
2k
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
154
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 ...
- 372
0
votes
0
answers
859
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 ...
1
vote
0
answers
977
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....
- 11
1
vote
2
answers
366
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
- 263
0
votes
0
answers
26
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
168
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
376
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
427
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
38
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
1k
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 ...
- 271
0
votes
1
answer
367
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
104
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
1k
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
0
votes
0
answers
199
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 ...
- 389
0
votes
1
answer
104
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 ...
- 9,981
1
vote
2
answers
570
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
38
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
3
votes
2
answers
16k
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 ...
- 55
0
votes
2
answers
492
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 ...
- 289
0
votes
1
answer
859
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
165
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
873
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
496
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
6
votes
2
answers
12k
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?
- 277
0
votes
1
answer
455
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 ...
- 11
0
votes
1
answer
126
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 (...
- 1,728
0
votes
1
answer
860
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 ...
- 11
0
votes
1
answer
1k
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 ...
1
vote
2
answers
130
views
12 In 24 working hours
How do I calculate the number of hours worked within 24 hours?
If the shift starts at 6 AM and finishes at 2 PM with a half an hour break, and the shift the following day starts at 4 AM and finishes ...
- 13
0
votes
1
answer
437
views
MS Excel - assigning recurring weeks that reset every month
I have a set of dates say in column A and want to associate custom week numbers that reset after every 5 weeks.
So for example, the week counting starts from 27/09/21 (Monday) and will end on 31/10/21 ...
- 11
1
vote
2
answers
16k
views
Why can't I change my date/time?
On the computers within my organization we can't adjust the date/time from the settings.
(The black mark covers "Time server: [server name]")
I have been looking at various websites and ...
- 21
0
votes
1
answer
2k
views
how to sum up mm:ss in excel column into 1 cell?
I have this time periods and want to see the total duration of all cells.
I used sum(d3:d100) , but it does not work.
I did format entire column of periods as time.
- 113
0
votes
2
answers
1k
views
How to *format* time duration as hh:mm:ss in LibreOffice/Excel?
I would like to copy the time duration (in seconds) to a cell, then have it displayed as (hh:)mm:ss or similar. For example:
Input: 0.49
Display: 0.49 or 0.49s or 490ms (any will do)
Input: 857.26
...
- 133