Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
10 views

Representing time as a duration in Microsoft Power BI

I have an Excel spreadsheet containing video statistics. One of those statistics is the length of the video as a duration. When I import this data into Microsoft Power BI, it can be represented as ...
0
votes
0answers
34 views

Why do monitors have such a long startup time? [on hold]

Basically all computer monitors need at least 5 seconds to turn on. My iiyama G-Master GB2888UHSU monitor needs 10 (!) seconds to switch on from off-state and on waking up (from sleep mode) it takes 8 ...
0
votes
0answers
34 views

Excel Formula : Find out time spent in specific time ranges

Trying to work out a slightly more complex overtime worksheet here: Employee gets paid: 1x hourly rate during weekdays (Mon-Fri) during 08:30 to 17:30 1.5x hourly rate during weekdays (Mon-Fri) ...
1
vote
1answer
49 views

Windows Time - The computer did not resync because no time data was available

I was following the instructions in the second answer of this question when the following popped up when I tried to sync Windows Time to pool.ntp.org: C:\WINDOWS\system32>w32tm /resync Sending ...
0
votes
1answer
19 views

Time synchronization with Daytime Protocol

I have a Windows Server 2008 R2 and for some testing purposes I need to sync the system time with the NIST Internet Time Servers using the Daytime Protocol. The sync needs to occur 3-4 times a day, ...
1
vote
1answer
58 views

Benchmarking bash commands with time and tee

I have a directory containing more than 80GB of simple text file databases that I anticipate needing to grep through often. For this reason, I'm trying to create some tests to compare GNU grep with ...
-1
votes
1answer
36 views

Why is my computer clock not refreshing?

Since about 2 weeks my computers clock does not update on boot anymore for some reason. It does not fall back to a certain date and the CMOS Battery is at 3.288V (checked both with Open Hardware ...
0
votes
2answers
75 views

Excel 2016 how do i enter & add time (mm:ss)

I want to enter a length of time in minutes & seconds only into cells, and then add them together. I need to do this for time played in sports statistical reporting. I enter the time in minutes ...
2
votes
2answers
114 views

What is the purpose of being able to set a time at a unrealistic point of time? [closed]

When fiddling around with the time settings on Windows, I noticed that you can set the date at an unrealistic point in history. Why is this possible and what's its purpose? Did Microsoft and other ...
2
votes
2answers
37 views

Weird characters for date in Win 7 explorer

As per the screenshot be.ow, what would cause the date to be displayed like that but the time be fine? This is on a work computer for my girlfriend. I was helping her get a new printer/scanner setup ...
0
votes
0answers
138 views

Windows was synchronizing with time.windows.com. The following error occurred: The specified service has been marked for deletion. (0x80070430)

Windows was synchronizing with time.windows.com, or any other time source. while updating it I got the following error: An error occurred while windows was synchronizing with time.windows.com This ...
0
votes
1answer
31 views

Can an email's date and time be falsified in Outlook?

I received a copy of an email that shows the date and time it was sent and to whom it was sent. I have reason to believe this is not a true email. Can it be proved that the date and time sent was ...
0
votes
1answer
15 views

Excel MOD function/countif logic work around the 12am point

My question is similar to this one in that I'm struggling with Excel's Mod formula. Mostly I just wish for clarification on how Mod function works in relation to time and if I'm making this harder ...
1
vote
1answer
83 views

How do you round a time and date back to a previous day with a formula in excel?

I am trying to sum up hours for an employee worked in one shift. The employees I'm having a problem with are on night shift. The employees entries in excel are shown as individual tickets for work ...
0
votes
1answer
27 views

Want to set an environment variable with TIME /t

I want to set a Windows environment variable from the results of TIME /t. In Windows, the %time% variable yields one format (13:17:52.79), whereas TIME /t has another (01:17 PM). I've tried ...
0
votes
0answers
70 views

NTP is not syncing with an external time server

I'm trying to sync with an external NTP (pool.ntp.org), but the server is responding with this message: This is the Wireshark capture. Network Time Protocol (NTP Version 3, client) Flags: 0xdb, Leap ...
0
votes
1answer
122 views

How do you change the time of the Linux hardware (hwclock) clock to 24-hour format?

Currently, my hardware clock returns the date/time (hwclock --show) like this: Sat 28 Jul 2018 08:47:47 PM BST .659124 seconds And date returns: Sat Jul 28 21:23:13 BST 2018 I'd like to change ...
0
votes
2answers
77 views

ActiveCell.Value = Time vba without seconds

I have a "timesheet" macro for clock in and clock out times for employees to use at work. The macro I have is this: ActiveCell.Value = Time ActiveCell.NumberFormat = "h:mm AM/PM" It works well and ...
0
votes
0answers
65 views

Active Directory client PC unable to sync time from server

I am running Active Directory on a Windows Server 2016 VM. The server is syncing via NTP with an external source and other PCs on the network are syncing time correctly with the server but I have one ...
0
votes
2answers
90 views

How do computers, and computer-like devices such as phones, keep track of time? [closed]

I always wonder how timekeeping works on any electronic device; the basis on which it increments time units, such as every second or micro second. Somewhere I read it works with a battery; but how?
4
votes
1answer
408 views

Is there a way to show 24 hour time format in Skype 8?

After upgrading Skype 7.x to 8.x, the timestamps of messages are shown in the "American" format (like "8:55 PM") instead of 24 hour format ("20:55"). I have Windows 7 and all other software uses the ...
0
votes
1answer
74 views

cmder: How to add time taken since last command

as discussed already here on SU there is a way to output the current date and time in cmder. In some videos on Youtube i saw some people installing something or get node.js ready or any other command ...
2
votes
1answer
70 views

Time among computers and servers are off

I'm trying to get all my computers time to sync. I have a Windows Server 2012 with hyper-V. Running on the Hyper V is: a VM DC - parent Hyper-V is part of DC's domain a VM IIS server (workgroup) I ...
0
votes
1answer
94 views

Filling in the missing times of a broken time series set of data

I downloaded per minute data from Google Analytics. However, it only provides a line item for each minute that there is a value greater than zero. I would like to graph this data, but before I do I ...
0
votes
1answer
38 views

Formula for checking time differences

I have the following setup: In cell A1 the time is = 09:30 In cell B2 the time is = 16:30 In cell C3 I would like to display a percentage based on the following criteria: If B2-A1 is less than ...
4
votes
3answers
209 views

How can I stop Linux from changing Windows's clock?

I have a computer (HP-e010nr) that dual-boots Linux Mint 18.3 (Cinnamon, 64-bit) and Windows 8.1 (64-bit). Both are installed via BIOS compatibility mode (the Windows installer refused to use UEFI). ...
0
votes
4answers
302 views

Excel - extract hours/minutes from time more than 24 hours

The displayed value in A1 is 177:53:00 The custom format is [h]:mm:ss The value when I click A1 is 1900-01-07 9:53:00 AM I need to extract the hours (177) from the cell to another cell Couldn't ...
2
votes
1answer
27 views

DDD, MMMM, YYYY, HH: MM nested script in word 2016 [closed]

I need to "nest" a script to include DDDD, MMMM, YYYY, \ HH:MM to portray like this; Saturday, March 15, 2018, 09:40 AM. I know how to write the date and the time separately but I would like to know ...
0
votes
0answers
232 views

instantaneously sync time via NTP after large offset on win10

One of my Win10 machines has a large time offset, in the order to weeks (its a VM that gets unpaused on request). In the age of short-lived SSL certificates, it is crucial for many (web-based) ...
2
votes
0answers
45 views

Report on users log-in total time in Windows 10 [closed]

I've often tried to find an answer to this, but no luck googling it yet. I imagine an app, or script, that can total up the total time each user has been logged into the PC. This seems trivial in ...
0
votes
1answer
29 views

Find Files with the same time

I have a directory which contains pairs of files. Unfortunatley, the naming scheme of the files is a mess, therefore it is very difficult to associate the pairs to each other by file name. BUT: each ...
0
votes
0answers
22 views

Why does invoking program by full path name give different result?

time ls prints: main main.c real 0m0.001s user 0m0.000s sys 0m0.000s /usr/bin/time ls prints: main main.c 0.00user 0.00system 0:00.00elapsed ?%CPU (0avgtext+0avgdata 2468maxresident)k ...
0
votes
0answers
159 views

“Adjust for daylight saving time automatically” not active in Win 10; time is therefore wrong

The option "Adjust for daylight saving time automatically" is greyed out, so I cannot turn it on. Even with the "Set time automatically" option turned off, the "Adjust for daylight saving time ...
6
votes
2answers
416 views

What is Windows's time server synchronisation precision? (and does it compensate the ping time?)

For the project described in Application of this question I need the best time clock precision possible, and one solution is to have a precise synchronisation of the computer's real time clock. What ...
2
votes
1answer
48 views

Excel: How to type in date and time, like “1/23/1945 16:20:14” (not Ctrl + ;)

I need to enter various time points including y,m,d,h, m, s. Examples: "1/23/1945 16:20:14" "1/23/1967 08:00" Excel only recognizes above as text, not saved as serial number. Any format for entry is ...
1
vote
1answer
37 views

Attempting to calculate billing from time

I'm using a time tracking software that outputs to a csv. I know I can't just multiply my rate by the time value (see image, where I'm just translating the value to a cell formatted as "General"). ...
0
votes
0answers
44 views

NTP synchronization on win10 pro x64

I'm trying to find how to set up on Windows 10 Pro time synchronization from three different NTP servers as on the picture. I have three time sources - two with a GPS signal and one DCF77 source. ...
2
votes
1answer
356 views

Windows 10, Date/Time changes by itself. Keeps jumping a full month ahead. Ideas?

Logged on twice and each time the date jump from current day in May to middle of June. Ideas?
0
votes
0answers
16 views

Return the time of each keyframe in the given movie with ffmpeg [duplicate]

I am currently working on keyframe extraction from videos. codes ff = FFmpeg( inputs={file_path: None}, outputs={target_path+'/Thumb%03d.png': ['-vf', 'select=gt(scene\,0.3), scale=640:360' ,'-...
0
votes
1answer
35 views

How do the w32Time service get the time?

We have a Problem on a PC with Windows 10(new installation, reinstalled and refreshed), to make updates the PC was also online. But also offline, the Time is changing randomly to a Date in the Future ...
0
votes
0answers
159 views

How to enable “Change Date and Time” Windows 10v1709

In Settings->Time & Language->Date & Time , the 'Change' button is greyed out and a red 'Some settings are hidden or managed by your organization' appears. This Windows 10 Pro v1709 PC is ...
1
vote
2answers
54 views

Can I get the value of a cell in Time format automatically pasted into another cell in Number format so I can apply a Sum function

I have an employee work schedule all set up in Excel 2016, Windows 10. Cell C3 is “Time In”, C4 is “Time Out”, and D3 is the total number of hours for that day (i.e., I enter In 10:00 AM in C3, and ...
1
vote
4answers
136 views

'grep' does not work with 'time'?

Why does time ls | grep real output this real 0m0.002s user 0m0.000s sys 0m0.002s instead of just real 0m0.002s If I type echo -e 'real\t0m0.002s\nuser\t0m0.000s\nsys\t0m0.002s\n' | ...
1
vote
0answers
227 views

ntp sync issue after setting time with date command

one of our servers had not accessed the time server for a long time. After access is turned on; my colleague has notice date is wrong and setting time with date command. After this I have restarted ...
0
votes
0answers
56 views

Time seems to go little faster on my server

I have a Lenovo Think Server machine and it has few VMs in it. One of the VM's is a domain controller. All the computers connected to that domain gets the clock from the domain controller. I noticed ...
0
votes
2answers
180 views

How do I sort “2018-02-11/20:32:19” records in Excel?

I have series of data that are in format of 2018-02-11/20:32:19. And, I can't work out with formula because of "/" present without any space between date. That "/" some time creates barrier to apply. ...
1
vote
0answers
272 views

Windows time keeps changing automatically

Every 30 mins or sometimes much longer the system time changes with the event --- The time service has set the time with offset 15481355650727981 seconds. The time always reverts back 37 hours to ...
3
votes
0answers
80 views

Every blue moon my computer's time is slow, i.e. a second takes almost a minute to pass

So, here's the thing, I am absolutely lost what could be the problem here. Let me walk you through the symptoms my computer is showing, and the steps I tried to fix and/or identify the root of the ...
1
vote
0answers
146 views

How to configure a listening-only NTP client?

I'm creating an advertisement display, based on RaspberryPi (no real time clock present) and piCore, which is busybox-based tinycorelinux. It will be behind a firewall, and even within its own network ...
2
votes
1answer
52 views

Use Task Schedule to offset System Time

I have a Windows XP computer which is not connected to the Internet or to a network. As per this answer it seems to be an issue with the CPU or power voltage. It is a cheap offbrand computer with no ...