The tag has no usage guidance.

learn more… | top users | synonyms (1)

0
votes
1answer
22 views

Is it possible to force Windows 10 to display reminders about Daylight Savings?

One of my favorite features about previous versions of Windows as opposed to Windows 10 is how it reminds users at least a week in advance about Daylight Savings, which is always nice since it gives ...
0
votes
0answers
21 views

Linux Server wrong time [closed]

Few Linux servers fail to update/sync time from/with ntp server and go one hour ahead, what's wrong with them? (Timezone is set correctly. The problem is with offset which increases over time until "...
-2
votes
0answers
10 views

Google Sheets Format based on time of day and 2nd condition [migrated]

I have a sign-in sheet where attendees sign-in for their cases. I want to write conditional formatting for the cell to turn red if they have not signed in by 8:45am on the current date - so two ...
0
votes
1answer
46 views

Dual boot and automatic time reset issue

I have a dual boot PC with Windows 10 and Ubuntu 64 bits. It was Ubuntu 32 bits before, but that was reinstalled with 64 bits recently. Since then, the hour is off by 2 hours when I boot either in ...
0
votes
1answer
14 views

error checking date/time sync with ntpq

When I check the sync status using the following command I get a "Connection refused" error root@darkstar:~# ntpq -p ntpq: read: Connection refused root@darkstar:~# What is the cause of this and ...
3
votes
4answers
78 views

Determining whether specified time is within 15mins of target time in Excel

I’m trying to create spreadsheet to monitor the timeliness of backups executed. Backups must be executed within 15 minutes of the target time, in order to be considered compliant. The raw data ...
-1
votes
2answers
34 views

How to make an arbitrary Microsoft FILETIME?

I would like to make an arbitrary Microsoft FILETIME. The algorithm is more important than the Microsoft programming language. For example if today is June 2 2016, I would like to calculate the ...
0
votes
1answer
1k views

Excel Start Date with specific start Time

Date and time data is imported into excel from an outside source (excel see the imported data as Text so column Q is converting to date/time that excel will recognize). I am using multiple formulas ...
-2
votes
1answer
34 views

PC date and time incorrect

I have all my PS's connected to Domain(using windows server 2012r2). In all my PC,date and time automatically changes even after manually setting up through BIOS as well as system settings. In my PC,...
1
vote
4answers
102 views

Why does Excel not recognise and format dates consistently?

I'm using data connections in excel to link to data exported from another software package. The analysis I do relies on dates captured by the software and it is very helpful to group by the dates and ...
0
votes
2answers
21 views

How to find the number of rows that have date time fields between 5 and 6 PM

I have a phone log that I want to report some data off of. All of the solutions out there that I have looked up seem to assume I only have a time value and that they don't include an actual date. I ...
0
votes
1answer
34 views

Trying to find info about Y2K “Hardware” sold on infomercials during the late 90s [closed]

In Australia in the late 90s during the height of the Y2K scare, I recall watching one of those "after the morning news" talk show programs (which was softer news, interspersed with segments that were ...
0
votes
2answers
32 views

Subtracting hours

I'm working on a time tracking sheet. I have a weekly total column with the formula of =SUM(I4:I8). This entire column is formatted as [h]:mm. The current value is 31:49. I want to calculate how ...
0
votes
0answers
21 views

ntpdate pool.ntp.org getting lost on slackware

On Slackware 13.1, keep time correct is getting difficult. I've noticed BIOS clock is wrong. So I do ntpdate pool.ntp.org and just after I check time with date. It's correct. I check it again with ...
1
vote
1answer
57 views

Calculating the average Interest Rate using a range of date inputs in excel

I need to calculate the average interest rate for a calendar year, based on a table of exchange rates which change at various dates. The table simply shows the start date and end date of the set ...
0
votes
0answers
18 views

Count number of minutes in each hour of a period defined by start and finish times in excel

I have a big number of records in excel which have a start date/time and an end date/time Event name Started Ended Event1 25/3/2016 01:55:10 25/3/2016 06:15:50 ...
1
vote
0answers
88 views

How to modify the timestamp for a files “creation date” to show only the date, without time in File Explorer

Okay, so I know I can change the format of the time-stamp in my computer settings. If I change short time to blank, then I have the outcome I am looking for. However, it changes ALL my system short ...
2
votes
1answer
782 views

Windows 10 automatic daylight savings adjustment not working?

I have a single Windows 10 machine. It is not connected to a domain. Pretty stock. Daylight savings time changed this weekend, and my computer is not showing the correct time. I've rebooted it with no ...
0
votes
1answer
51 views

Formula stopped working after changing date field to calculated

Why do I get different results for B2 and C2? Here are the two formulas: 0:00 = =SUMIFS(tblTrack[Spent],tblTrack[Time Ended],">="&E9) 6:32 = =SUMIFS(tblTrack[Spent],tblTrack[Time Ended],"&...
0
votes
1answer
38 views

General questions about entering minutes into an Excel worksheet

I'd like to be able to enter minutes into Excel cells and have another cell that totals the minutes. I have no problem converting minutes into hours. However, when I enter information, I don't want ...
-1
votes
1answer
58 views

prevent duplicates in excel is easy but

We all know how to prevent duplicates in excel by using data validation and the custom formula : =COUNTIF($A:$A;A1)=1 for example. but I need to add a time condition, so every day I'm typing some ...
0
votes
1answer
37 views

time format in Excel [duplicate]

How to get desired output in MS Excel? note that the outage duration is in mins Start time Outage Duration (in Mins) DESIRED OUTPUT 3:12 AM 60 4:12 AM 4:05 PM ...
1
vote
1answer
79 views

How do I sort files by date in filename?

I have a set of filenames like this vorlesung 02.11.15.mp4 vorlesung 04.01.16.mp4 vorlesung 07.12.15.mp4 vorlesung 09.11.15.mp4 vorlesung 09.12.15.mp4 ... The last part of the file name is a date ...
0
votes
0answers
18 views

Correcting the time of day clock of a restored VM

In VirtualBox, a VM's state can be saved and restored at a later point in time. This requires it to sychronise its time of the day clocks to the later time. How is this acheived, even when the OS in ...
2
votes
1answer
1k views

Can't sync windows 10 clock to the internet

I am having a serious problem with my computer. I simply can't sync the clock on my windows 10 running machine to the internet. When I go to "Date and time settings" and turn the "Set time ...
3
votes
3answers
66 views

Is it possible to virtualize the clock for an experimental NTP time offset?

I have a project that wishes to force the times of a set of private NTP servers to demonstrate how NTP (and our software) reacts to various time changes and differences, network lag, etc. Normally, ...
0
votes
0answers
21 views

Bi-weekly summing and conditional formatting in Excel

How can I sum only the daily wages of the dates belonging in bi-weekly range and format the borders to look like this? (Sorry not enough rep here). In this case, the cell the arrow is pointing to ...
0
votes
1answer
39 views

Subtract certain hours from a time in Excel

I want to know the time when 12 hrs and 30 mins is subtracted from a time let us say 10:00 AM(it should display 9:30 PM). But since Excel, by default, stores this date as 1st Jan 1990, I am getting a ...
0
votes
1answer
268 views

Displaying data in Excel graph only up to current date?

I have an Excel chart that displays 5 sets of data in a single scatter plot, where the X axis is the date of occurrence. In my table, I have both actual values from previous dates and projected values ...
0
votes
2answers
55 views

Why two O/Ss on the same machine have a 1 hour clock difference?

My machine has two O/S, a Linux distribution (primary) and a Windows 7 (used seldomly). Both O/Ss are set on my time zone (UTC+1). Depending on how I set the time on the BIOS, either Windows shows ...
0
votes
0answers
25 views

How to calculate time differences with condition

I have a table with 2 columns consists of: TIME of order and CUSTOMER name. I need to find the time difference between orders for a specific customer. TIME CUSTOMER 12/30/2015 23:59:53 STY 12/30/...
3
votes
1answer
126 views

Work out Start Time + Hours with working days and times

I have the following problem: In G4 I have 19/01/2016 10:00 In F4 I have the value 200 (units) In E4 I have the value 38 (minutes) I want to calculate G4 + (E4*F4) i.e. 19/1/16 10:00 + 7,600 ...
1
vote
1answer
77 views

Force domain PC to sync time with another domain PC

I thought this would force workstation 12, at 14:53 (time) to sync with whatever time was on workstation10. at \\workstation12 14:53 net time \\workstation10 /set When I execute the command, the ...
4
votes
1answer
209 views

Adding date stamp to vlc recorded streams

I have few bat files created to record my favorite audio streams but I would like to include the dates in the output file. Is there a way to include the date in the output file name with the code ...
0
votes
0answers
180 views

windows 10 clock bug?

I bought an ASUS K501U, i7-6500U machine. It runs Windows 10 unfortunately, but that's what new machines come with. When it arrived, the internet did not work. Every site claimed that the ...
0
votes
0answers
28 views

How to show weekday beside the time in Windows 10 clock in taskbar? [duplicate]

I want my taskbar buttons to remain small and display the weekday next to the time instead of below the time. For example the display should look like: Wednesday 21:43 I am okay with the date not ...
0
votes
2answers
129 views

Changed windows system clock now date modified of files are wrong

I was working in Visual Studio 2013 and testing some code for event handling on specific dates. I changed the Windows clock to be 1/1/2016, compiled code in visual studio (specifically a web project ...
0
votes
1answer
90 views

How to have Excel recognize date in format MMM YYYY (e.g. Mar 2015)?

I have a system that has outputs reports to Excel but Excel does not recognize the format as a date--"Mar 2015" to be "Mar-15". This makes pivoting the data hard because the date column is sorted ...
0
votes
0answers
35 views

Windows 10 Big Time Doesn't Have Leading Zero

I have my Windows 10 time format set to HH:mm:ss but for some reason, after clicking the time and date in the right hand corner, the time that appears doesn't have a leading zero. Is there any ...
1
vote
1answer
124 views

DSQuery get lastlogon date in active directory

I need the lastlogon field of my domain computers exported. I used this command: dsquery * domainroot -filter "(&(objectCategory=Computer)( objectClass=User))" -attr distinguishedName ...
0
votes
1answer
42 views

How do I calculate the total busy time between several start-end dates

I have a table like this: Event Start End 1 1/1/2015 10:00 1/1/2015 10:05 2 1/1/2015 10:02 1/1/2015 10:07 3 1/1/2015 10:10 1/1/2015 10:12 I want ...
2
votes
1answer
181 views

BIOS date/time reset

After 5 years of heavy use, I noticed that my laptops fan is constantly on, so I decided to change the thermal paste of the cpu. Everything went fine except for some strange reason my laptop keeps on ...
0
votes
1answer
15 views

Time gets out of whack on Yosemite

Every once in a while the time gets out of whack on my MBP 2014 running Yosemite. Just right now I noticed it was roughly half an hour slower. I fixed it by going to the Settings->Time Zone, unlocked ...
1
vote
2answers
33 views

Display Date using small icons script how to add year?

I found ArtOfWarfare's script on this thread Windows 7 - display date using small icons I think it's great however it's missing one thing, the year. Is there anyway to add the year to the script and ...
0
votes
0answers
57 views

Is there a way to enter negative time into cell in Excel?

I am trying to enter a negative time value into a cell and receive the error "The formula you typed contains an error." I have tried changing to the 1904 date system but receive the same error. The ...
0
votes
1answer
33 views

Date range for jobs & conversions SUMPRODUCT

I'm trying to run a report within Excel that shows the total number of jobs completed by employees within a date range and also a count of the number of conversions per employee within the same date ...
0
votes
1answer
71 views

How do I change time format in Windows 10 Windows Update scheduler?

My Date & time format are set correctly as far as I can surmise, I live in Finland, but prefer English as my OS language, yet, parts of Windows 10 UI seem to follow the 10PM/AM style instead of ...
0
votes
0answers
25 views

Archive differently named folders with 7zip in batch file

I want to write a batch file that will use 7zip to archive folders with certain names. The names will be different each time the batch file is run because the dates change. YYYY-MM-DD will represent ...
2
votes
1answer
125 views

Excel 2010: Daylight Savings - calculate # of hours between timestamps for any given day

I have a checksheet which cross-checks various water measurement points, reading the average rates from around thirty different meters out of another system. I've automated this checksheet so a VBA ...
0
votes
0answers
45 views

Time Synchronisation on Guest Domain Controller

We have a Domain Controller hosted within Hyper-V on a Server 2008 OS. Recently, we noticed that the time on our local machines was out by a few minutes at this site. After some investigation, I ...