Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
alireza Seraj's user avatar
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 ...
quarague's user avatar
  • 101
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 ...
Lance's user avatar
  • 377
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: ...
user2495207's user avatar
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 ...
Dominique's user avatar
  • 2,183
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 ...
mscher's user avatar
  • 1
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
infinitieunique's user avatar
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 ...
Ron Partuk's user avatar
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.
Jonas Stein's user avatar
  • 1,092
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\...
Cpt.Whale's user avatar
  • 7,566
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 ...
Rami RoMa's user avatar
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 ...
ceremcem's user avatar
  • 605
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 ...
Vladimir Zolotykh's user avatar
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 -> ...
user avatar
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 ...
retriever123's user avatar
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 /...
user avatar
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"...
Bricktop's user avatar
  • 313
-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&...
Colin Dakin's user avatar
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.
Sunil Kumar Das's user avatar
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 ...
hassam's user avatar
  • 11
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 ...
Ramma's user avatar
  • 3
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 ...
Baba Yaga's user avatar
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 ...
leigero's user avatar
  • 382
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 ...
asgasehswheeshss's user avatar
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....
Brian Cook's user avatar
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
zeros's user avatar
  • 267
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 ...
Nophakhit Khositchaiphithak's user avatar
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 ...
Geographos's user avatar
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 ...
Sina S.'s user avatar
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 ...
Vladimir Zolotykh's user avatar
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 ...
Geographos's user avatar
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 ...
Oast's user avatar
  • 291
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() ...
2Took's user avatar
  • 3
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 ...
Rizwan Ahmad's user avatar
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 ...
user167420's user avatar
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 ...
SuperHanz98's user avatar
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 ...
Albin's user avatar
  • 10.4k
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....
vesperto's user avatar
  • 184
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 ...
Tracy LF's user avatar
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 ...
dEhiN's user avatar
  • 65
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 ...
Susie Derkins's user avatar
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 = ...
larsnl's user avatar
  • 1
-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 ...
t09's user avatar
  • 3
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 ...
dubtott's user avatar
  • 11
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 ...
Mand's user avatar
  • 143
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?
James Geddes's user avatar
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 ...
user1553584's user avatar
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 (...
Basj's user avatar
  • 1,749
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 ...
user1553584's user avatar
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 ...
MGM_SP_34's user avatar

1
2 3 4 5
11