Questions tagged [time]

Time is an element of the overall measurement system of for space. Time can refer to the time it is now, according to timing devices, the interval between two events, the duration of an event, or the sequence of events.

Filter by
Sorted by
Tagged with
0 votes
1 answer
102 views

NTP sync fails but NTP servers are reachable on Windows 10

I can't get my clock to sync in Windows 10. When asking for a sync in either the control panel, or by doing w32tm /resync my computer sends some NTPv3 packets to pool.ntp.org (I manually set that ...
ComputerUser121212's user avatar
1 vote
2 answers
36 views

Ubuntu clock jumps but time is kind of correct

My Ubuntu server No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04.4 LTS Release: 22.04 Codename: jammy Linux lab01 6.5.0-26-generic #26~22.04.1-Ubuntu SMP ...
NicoCaldo's user avatar
  • 113
0 votes
0 answers
111 views

My Windows time changes to the future and causes problems. How can I fix this?

My Windows time changes to the future (this last time somewhere in 2042). My system is: X570S Aorus Master @Bios Gigabyte 4.21.1027.1 My OS is: Microsoft Windows [Version 10.0.22631.3155] (c) ...
Wilbert's user avatar
0 votes
2 answers
78 views

systemd-timesyncd: fails on boot due to ordering cycle (dbus, sysinit)

i've been having a hard time with a pretty basic Rocky Linux 9 setup where my systemd-timesyncd unit consistently fails on boot. here are the logs Feb 12 18:22:17 bigpu systemd[1]: sysinit.target: ...
Valentin Iovene's user avatar
0 votes
1 answer
40 views

Adding date and time to excel document quickly

I am making a log and need to keep track of multiple items parsing through different stages. For further statistical analysis I need to have date and time added to each stage for the particular item. ...
Sharkcoder's user avatar
0 votes
2 answers
49 views

Count number of instances that occur in a range across a month

I am looking to try and work out how many times across a month a message was posted between specific times, but not a specific date. Messages can be sent at any time, and I need to calculate how many ...
PBA24's user avatar
  • 3
0 votes
1 answer
211 views

Can't connect to any ntp server from windows

I have three windows computers that I'm trying to sync to an NTP server. All of them fail to do so. I have confirmed that the NTP server runs fine by connecting from WSL. Here's what I've tried: I ...
train_man's user avatar
0 votes
0 answers
49 views

How to setup the windows "window time" service so the service will always synchronize the time after startup? [duplicate]

Currently on windows 10 the startup type is "automatic (trigger start)" for "windows time", but every time I start in windows the time is in UTC and not the local time. So every ...
Alex's user avatar
  • 666
0 votes
0 answers
24 views

Formula to identify where there is a value for '0' and '1' per date in Excel pivot table

I am analysing camera trap data looking at nocturnal denning sites. I have formatted my data so that I have a '0' value and an '1' per date when there is an animal entering and leaving a den site on ...
Mike's user avatar
  • 1
0 votes
0 answers
11 views

timedatectl set-local-rtc --adjust-system-clock don't change the 3rd line of /etc/adjtime

man page says about set-local-rtc: This command will change the 3rd line of /etc/adjtime. The 3rd line changed when timedatectl set-local-rtc <true/flase>. The 3rd line not changed when ...
Wot's user avatar
  • 11
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
330 views

System time synchronized with the hardware clock

From the last 2 months, we are facing below issue on our Windows 2016 server every 10 days. Server time is going back by 1 hour with the below message in eventvwr. The system time has changed to ‎2023‎...
Sowjanya's user avatar
0 votes
0 answers
13 views

Measure the Max Memory of a running process in gcc-bookworm Docker image?

I found many resources to use valgrind or /usr/bin/time. However, I need to perform this task in the container of the official Docker image for GCC: https://hub.docker.com/_/gcc This image is based on ...
Stefan Zhelyazkov's user avatar
0 votes
0 answers
63 views

Windows Server 2008 R2 Time Stops

I have a recently re-imaged tower server running Windows Server 2008 R2 that is "freezing" time. After booting up the server, everything is working fine. I click on the time in the task bar ...
Alex's user avatar
  • 111
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
30 views

Windows App Keeps changing time randomly

I faced a time problem this week, i have a Network camera app that runs based on multiple servers. the servers storage is where the camera recordings go. Now everything was fine since the first ...
Bobaker's user avatar
0 votes
1 answer
90 views

Convert duration in XXm, YYs format to time value

In Microsot Excel, I have string data that represents duration of an event: duration 40s 5m, 40s 59m, 59s I need to convert the values to time (in adjacent column) so that I can format and sort ...
Salman A's user avatar
  • 1,722
0 votes
0 answers
193 views

How to divide time by a constant in Excel?

I have an Excel sheet in which I have a column where each cell holds the amount of overtime accumulated since the first row. The format of this cell is [h]:mm. In the column next to it, I want to ...
Joe's user avatar
  • 313
0 votes
1 answer
162 views

Why does Excel's now() function returns different times depending on device/browser used?

I am using the current time to run 'live' calculations in Excel using =NOW(). The Excel file is saved in my OneDrive. When I embed my Excel worksheet on a web page sometimes it displays the local (...
Jeremy Selig's user avatar
0 votes
1 answer
280 views

Ignore blank/0 values in AVERAGEIF with two ranges

Trying to calculate average waiting time but, need to ignore blank or 0 value cells. For example, here i'm calculating time difference between H column and G column and getting the average. However, ...
Sharkcoder's user avatar
0 votes
0 answers
103 views

Excel, populate time when another cell has data

Somebody else asked if there was a way to automatically populate the current date in a cell based on another cell receiving data. [NOT those exact words, but same thing, I think] And Somebody showed ...
Michael Morton's user avatar
0 votes
1 answer
678 views

Windows w32tm not answering NTP requests

I'm trying to setup an NTP server on my Windows machine. I'll give you a quick overview of the architecture I'm aiming for: The setup is as follows: on the Windows computer there are two network ...
Hadron's user avatar
  • 113
0 votes
1 answer
367 views

How to convert time to seconds

I have csv file with cells that have values like 0:20.555 and 12:05.001. The format is mm:ss.sss where mm is minutes,ss.sss is seconds with thousandths of seconds. It is a duration, not time of day. A ...
user1813005's user avatar
4 votes
1 answer
2k views

Seconds in taskbar gone after update KB5027231

A few months back, Windows 11 got an update that allowed you to show seconds in the taskbar clock like you could in Windows 10 and previous versions. It worked fine for a while, but when the ...
Kurausukun's user avatar
1 vote
0 answers
37 views

Conflicting time-zones being reported at the terminal

I am using Linux Mint, and while inserting times using Org mode in emacs I noticed, the times inserted are in Eastern Standard Time, America. That was confusing since I am based in India. After ...
smilingbuddha's user avatar
0 votes
1 answer
17 views

Trying to Sum data within a selected time period (in decimal years data)

Snip from Excel showing data I am using, I am trying to Sum column "Cum.Fire" but only want to select data starting from 2019.667 in the "time in decimal column". How do I do this?...
Natalie's user avatar
0 votes
1 answer
150 views

Pull System Time From Another Computer on LAN

I have a Windows 10 computer that has no internet connection. Whenever I power off the computer, the clock stops running, and since it has no internet connection, it cannot re-synchronize the time ...
EllipticalInitial's user avatar
0 votes
2 answers
1k views

Tenda AC9 - Current Time: 1999-12-31 18:31:13 (unsynchronized with internet time)

I have a Tenda AC9 (AC1200) and I can not change the date that appear on time settings and I do not have any manual changes or automatic internet one to synchronize, so this problem started 1 day ago ...
Razvan's user avatar
  • 1
1 vote
1 answer
1k views

NTP Time Wrong on ntp.org?

My Windows Server 2012r2 server (vm inside of esxi) is going crazy and thinking that it is Dec. 2, 2033. The oddest part about this is that it is saying that is what NTP is telling it. 20:25:23, -...
PressingOnAlways'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
0 votes
0 answers
68 views

Dell inspiron 14 5000 does not sync to correct time zone after change from GMT to BST and vice versa

My laptop - Dell inspiron 14 5000 - does not syncronize to the correct time zone after a change i.e. when the UK goes from GMT to BST or vice versa. I am able to "fix" the time by pressing ...
dilan_s's user avatar
0 votes
0 answers
175 views

NTP service not taking into account its config file

On Raspbian Linux 10, configuring NTP drives me crazy. In /etc/ntp.conf there is this line: logfile /tmp/ntp.log However, the systemctl start ntp service doesn't print anything into this file. When I ...
Daniel's user avatar
  • 547
0 votes
1 answer
187 views

Systemd timer OnCalendar based on instance name with calculation

I have a systemd timer that is templated. The instance names are all just integers ([email protected] etc). Is it possible, in the OnCalendar directive, to have the calendar expression perform basic ...
dodexahedron's user avatar
1 vote
1 answer
4k views

w32tm do not sync with configured Ntp server (source is clock)

On an Windows 10 workstation configured to connect to a local time server(the peerlist contains only one NTP server present in the local network). But when inspecting the configuration with "...
Claudiu Cruceanu's user avatar
-1 votes
1 answer
175 views

Find the total time of all videos (.avi, .flv, .mkv, .mov, .mp4, .swf, .webm, etc.) in a directory using only DOS commands (Windows / .bat) and

I would like to have a .bat file that finds the total time of all videos (.avi, .flv, .mkv, .mov, .mp4, .swf, .webm, etc.) in one directory with no other frills. I want to use only DOS commands (...
SuperMusketeer's user avatar
1 vote
0 answers
51 views

Display another time than the system time

I'm one of those people that is constantly late for everything. Therefore I set my PC clock 5 mins into the future. So if it's 08:45 AM, I already see 08:50 AM on my computer. Some apps however ...
SimonS's user avatar
  • 9,244
0 votes
1 answer
895 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
0 votes
0 answers
70 views

journalctl entries are logged using the same time, in 5minute intervals

I have a service which queries a database every second and print out results to console. When I look at journalctl I get a couple hundred lines that all have the same timestamp, and then the next ...
frend123123's user avatar
0 votes
0 answers
343 views

How to set SSH time to the Windows machine time

I am a beginner in these things, so please go light on me! At the suggestion of a community member, I ask this question here, in addition to StackOverflow. I have a device which I connect to my PC (...
CapnJackSparrow's user avatar
0 votes
1 answer
1k views

chrony sync too slow how to immediately sync time

And I'm using debian 11 with chrony for server-cluster time sync. The question is: How to immediately sync the clock? I even tried to use this total crazy config makestep 3600 -1 Then restart, Then ...
Alceatraz's user avatar
  • 105
0 votes
1 answer
42 views

Does turning back time affect pc

If I were to set the date back (same year, different month) -- resave a file from its original date (just for the heck of it) -- then set the date back to current, will that affect anything?
Stanley's user avatar
1 vote
0 answers
171 views

Thunderbird notification only in workingshours

I would like to receive thunderbird notifications only between 9 to 5, when an E-mail arrives. But I can only enable and disable it generaly under Settings -> Serverkonfiguration. How can I ...
stupidstudent's user avatar
0 votes
0 answers
83 views

FFmpeg possibilities script

I would like to ask for advice. I have a video .MTS file. I need to add "paste" time (time track) to a new video file. I mean a time in the frame on the picture. In the same step I need to ...
user1729496's user avatar
2 votes
3 answers
364 views

Is there any way I can measure the runtime of a program in DOS?

I just want to measure the time it takes a program to go from start to finish. In UNIX - I can use the time command. Is there any way to do this in a MS DOS or FreeDOS?
Coder's user avatar
  • 121
0 votes
0 answers
461 views

How long does a Time Machine changes update should take ?! (it takes forever)

I've recently upgraded my OS, and after doing that - my Time Machine takes forever to update... I mean it's more than 24H now, finding changes... more than 370,000 changes found and still counting. I ...
Aviram Netanel's user avatar
0 votes
0 answers
15 views

Windows timezone/clock resets to UTC each time I switch to ubuntu and back to windows? [duplicate]

Well I have disabled all settings regarding "set the time automatically" and "adjust for daylight saving time automatically". I live in UTC+1. and am running windows 11 as well as ...
paul23's user avatar
  • 573
1 vote
2 answers
2k views

How to convert a sum of minutes to hours and minutes format

I have a column with minutes that are the result of a calculation (speed and distance). =(E7/$A$2)*60 =(E8/$A$2)*60 =(E9/$A$2)*60 These are displayed with a quote, using a Cell Format #0"''"...
Alexandr Meyer's user avatar
0 votes
0 answers
49 views

Need help adding the difference between times. 12:00 PM not working

So I want to find the difference between the hours and add them all up. But when I have use 12:00 PM (or am) as the time it returns 0. If I use 12:01 PM as in example 2 it works. If I have 12:00 PM ...
Gregory Drummond's user avatar
0 votes
1 answer
2k views

Line Chart vertical grid lines only for aggregated values (days, instead of hours)

I have two columns: day of week, hours (for each day) and number of things occurring on each hour of a specific day of week. Below an example with first two days: I want to plot these data as a line ...
Michele Cordini's user avatar
0 votes
1 answer
29 views

How to calculate how many days have passed based on two cells values

I am trying to calculate how many days have passed upon receiving a PO after an NTP has been provided. The part I'm struggling with is that sometimes based on an entry there could be a blank in either ...
Mira's user avatar
  • 3

1
2 3 4 5
12