Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 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
25 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 ...
  • 103
0 votes
0 answers
97 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
56 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
29 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 ...
  • 103
0 votes
0 answers
28 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 ...
  • 233
0 votes
1 answer
42 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 email, based on contents of cells for To: Subject: Body: fields. Subject: cell contains =NOW() and is properly displaying date/time. Problem - when ...
  • 3
0 votes
0 answers
20 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 ...
1 vote
1 answer
99 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 ...
0 votes
0 answers
26 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
31 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 ...
  • 8,254
1 vote
2 answers
34 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
29 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 ...
1 vote
1 answer
586 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 ...
  • 35
0 votes
0 answers
76 views

Data plotting over dates and times

I am trying to ploy data acquired by an instrument at roughly 3 hour intervals over 2 months duration. The format is dd/mm/yyyy hh:mm:ss. But when i create the graph it plots all data sets over one ...
0 votes
2 answers
159 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
225 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
58 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
438 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
0 answers
13 views

Windows Account Changing Time Ignoring Settings?

On every machine/Windows install I have while logged into a particular Microsoft account the system time changes on reboot. This does not happen if I have a fresh Windows install without the account ...
0 votes
1 answer
145 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 ...
  • 123
0 votes
1 answer
2k 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
319 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
78 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,444
0 votes
1 answer
241 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
247 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
125 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
0 answers
113 views

Archlinux cockpit using 12 hour clock rather than 24 hour

I have cockpit-project running on my Arch box and it keeps showing me 12 hour time (e.g. 7:00 pm) rather than 24 hour time (e.g. 19:00). How can I change this? My locales are: LANG=en_GB.UTF-8 ...
0 votes
1 answer
146 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 ...
0 votes
1 answer
3k 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 ...
0 votes
1 answer
716 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.
  • 103
0 votes
2 answers
529 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
0 votes
0 answers
110 views

How can I get the current time of my host PC from Linux virtual machine?

I have a Kali-Linux virtual machine installed on my windows 10 PC (using oracle VM VirtualBox) According to my timezone, the time is 11:26 I came across this problem: When I used datetime.datetime....
  • 101
0 votes
2 answers
162 views

=DATE() won't increment DAY when I try to drag or fill the other cells

I'm working on an excel file to track attendance. The excel sheet should have the flexibility of dynamically changing the year of dates. The user can enter the current year in a cell and it should ...
0 votes
1 answer
68 views

FileZilla: How to get updated German time?

I am using FileZilla for FTP and SFTP data server in Germany with FileZilla language English. When ever I am sending data or taking data from a server, I am getting time (last modified) which is ...
  • 127
0 votes
1 answer
119 views

How can I modify the programmable interval timer value stored in the computer so that the system clock runs faster?

According to this Wikipedia page (https://en.wikipedia.org/wiki/System_time#Implementation) computers use a programmable interval timer (PIT) that periodically interrupts (when reaching a certain ...
  • 11
0 votes
0 answers
453 views

Automatic time sync is not working in Windows 10

I have enabled automatic time sync. But time sync is failing in Windows. Fillowing is the screenshot of the error.
0 votes
2 answers
121 views

Calculate remaining time from end time that lies on next date

Shift begins in evening and ends at 05:00 in the morning I am looking to calculate in real time, how much time is left till end of shift. I have been using =NOW() in hh:mm format to calculate and end ...
1 vote
1 answer
36 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 ...
9 votes
3 answers
4k 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 ...
  • 177
0 votes
1 answer
268 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
2 answers
59 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
1 answer
886 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 ...
  • 1,466
0 votes
2 answers
437 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)
  • 101
1 vote
2 answers
312 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
0 answers
45 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
0 answers
34 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 ...
  • 11
0 votes
0 answers
40 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-...
  • 103
0 votes
0 answers
352 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
1 answer
100 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.
  • 1

1
2 3 4 5
10