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.

-3
votes
0answers
11 views

wrong duration of audio file [on hold]

my windows 7 only views the time in hours minutes and seconds. it is lying to me . so, in the details my computer only says 17 seconds. but audacity says it's about 17.687 seconds, can you make it ...
-1
votes
0answers
9 views

even after setting mac time manually (+30 min) , after restarting it retains original time

After setting the time setting of Mac, which runs OS 10.14, reinstate current actual time each and every time it restarts. I set the time of Mac +30 min past to current time for server and application ...
0
votes
1answer
40 views

Excel 2013 chart - setting time intervals in vertical axis

I have time (mm:ss) in the vertical axis of a bar chart.  I want to set the following parameters: min - 0 max - 12:00 major ticks: every 2:00 min (0, 2:00, 4:00, etc.) minor ticks: every 0.5 min (0:...
-5
votes
1answer
67 views

Windows saying it's PM when it's AM [closed]

In Windows 10, the clock is saying its 12:08 PM when it's 12:08 AM (noon). The bios clock is 24 hour format as is correct (12:08). I have the time zone set correctly (I'm in UK so its UTC+00:00). I ...
1
vote
1answer
109 views

Computers slow after not being used for a while

I've had an observation made over time, both with my PC refurbishing program and in personal experience. I've observed that PCs are slow when they boot up for the first time in months. This slowdown ...
0
votes
1answer
156 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
1answer
39 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
215 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
64 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
40 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
81 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
116 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
42 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
1answer
42 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
19 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
85 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
28 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
97 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
198 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
141 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
134 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
697 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
82 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
74 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
355 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
646 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
30 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
364 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
30 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
23 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
267 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
718 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
51 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
59 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
495 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
20 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
40 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
275 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
60 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
146 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
245 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
183 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
307 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 ...