The tag has no usage guidance.

learn more… | top users | synonyms (1)

0
votes
2answers
39 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
19 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 ...
0
votes
0answers
27 views

Why won't `date` accept it's own default output?

On my system right now by default date outputs: $ date Fri 29 Jan 22:04:26 GMT 2016 However if I try to feed dates of this format back into date it results in "invalid date": $ date -d "$(date)" ...
3
votes
1answer
68 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 ...
0
votes
0answers
43 views

How do i change my pc time without leave my company domain (win 10) [closed]

My PC is connected to my company domain and I'm wont to change the time without getting out of the domain ? Note: There is some ways that may change time but it returned to server time when I restart ...
4
votes
1answer
61 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
70 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
27 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
60 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 ...
1
vote
1answer
30 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
12 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
1answer
55 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
19 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
52 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 ...
2
votes
1answer
120 views

How to disable time sync with Windows 7 as host OS in VirtualBox?

I have a 64 bit Windows 7 with VirtualBox running the same 64 bit Windows 7 as a guest OS. When I set a specific date and time, it will always revert to the host OS’s date and time on startup. How ...
0
votes
2answers
303 views

How to disable time synchronization in Linux Mint

My system: Linux Mint 17.2 MATE 32-bit My settings: Menu -> Administration -> Time and Date -> Configuration = Manual (that means do not connect to internet time servers) I do NOT have ntp ...
0
votes
1answer
33 views

ffmpeg- using ffmpeg to take an image from camera and store it

The below file does most of what I want quite well. However, the time format seems not quite what I want. I would prefer to always get time in ISO8601 (e.g. 20150930T012823Z) regardless of the time ...
1
vote
1answer
43 views

How to ignore the date and just get information from the times

I am using the d/m/y h:m:s format, and I need to count how many entries I have within the same hour no matter the date. I was using: ...
0
votes
1answer
62 views

uneditable date-time source for vb.net ms access

We are trying to create a time-in/time-out system using vb.net and ms access as database. I'd like to ask for an uneditable source for our date-timestamp. We can easily use system time but users tend ...
1
vote
1answer
73 views

24-hours time with 12-hour notation [closed]

I've received an paper e-mail copy with header saying, that the e-mail was sent 15:10 PM. So I am wondering, if the mail is fake one, or is it possible due to some setting changes? My questions: ...
1
vote
0answers
104 views

EXCEL 2011 - Inventory with Matrix and Vlookup

I am creating an inventory matrix, which has on the first column a list of all the items in the inventory, and on the first row a list of the dates for when the inventory gets renewed. Basically, not ...
0
votes
0answers
74 views

How do I use Terminal on Mac OSX 10.10.4 to extend the time SelfControl Program is set for?

I would like to extend self-control beyond 1 day on Mac OSX 10.10.4 I found this terminal command below by Charlie dated 2012: "You can easily make SelfControl block for any length of time you ...
1
vote
0answers
116 views

How can I set 24 hour time in KDE5

It seems the new way to set your preferred date format is by country and language. I've never thought about this method but I guess it encourages people to be more multicultural, researching how ...
6
votes
4answers
4k views

How to show weekday in Windows 10 clock in taskbar?

In all windowses before 10 I could just pull the taskbar up and I could see which day it is: But when doing that in Windows 10 it doesn't work: How can I get my weekday back without having to ...
0
votes
1answer
19 views

date/time setting does not work after unplugging power adapter or sudden power cut in linux

For some reason, I want to configure the date/time in my Linux (CentOS 6.5) to be different from the REAL date/time, but the setting won't work if I turn my computer(desktop not laptop if this ...
3
votes
2answers
683 views

Can I customise the new Timeline slicer in Excel 2013?

Excel 2013 introduces timeline slicers for the first time. These allow you to filter pivot tables easily by selecting time ranges - either by year, quarter, month or day. It's nearly a useful tool, ...
2
votes
3answers
60 views

How to convert integer column to time column?

I am trying to format an integer column to a time column, but the values all end up as 12 like this: 12 12 12
-2
votes
1answer
49 views

If I change my computer's clock, will Area-51 think I'm on a different time? [closed]

On Area 51 Stack Exchange, you can only post 1 site proposal per day. What if I change my computer's clock? Will I be able to post multiple proposals per day? What if I change the clock back to where ...
1
vote
2answers
96 views

DATEVALUE() gives different values for similar data

In one column, I have timestamps in the format Jun 10, 2015 11:36:51 AM So, to get the date from that column, I created another column and used the formula =DATEVALUE(CONCATENATE(MID(D2,5,2)," ...
0
votes
0answers
36 views

Libre Office Writer : Date to Text-Date

here is what I want to create: A document/macro that reads the current date (which is easy) and transforms the date e.g. 2015/12/17 into text like this: the seventeenth day of the twelfth ...
-2
votes
1answer
223 views

How to calculate estimated moments with 8 hour work days

In my worksheet, I want to calculate estimated end times of processes taking into account workday timeframes. Assume working days of 8:00 - 17:00 and omit Saturday and Sunday. So, for example, when ...
0
votes
2answers
85 views

Linux Mint date not sync after reboot

I got a system date (time) problem since I upgrade using apt-get yesterday. The system date will set to a random date in the future (ie: 2030, 2027, etc. not the same everytime) after system reboot. I ...
0
votes
1answer
39 views

How to know since when a package has been installed on a linux system

How can I find out the date (and time if possible) of installation of any package on Linux Operating system. For Ubuntu and using apt-get
0
votes
2answers
111 views

Excel sees date/time value as text

I exported some data from a database as an excel file. One column contains date/time values in the following format: 2015-04-09 14:05:11.867 where the .867 indicate miliseconds. Excel reognizes ...
0
votes
0answers
12 views

automatic insertion of the date of filling an adjacent cell in excel [duplicate]

I have created an excel file for my company and several people have access to this file. because of that I need to know when a cell is filled. I want to dedicate a cell to show the date and time of ...
0
votes
1answer
47 views

Excel converts datetime to other format where days are low enough to be months

I live in europe and our datetime format is usually dd/MM/yyy I have an excel spreadsheet where I have ALOT of dates But for reasons I do not know, Excel converts where (dd < 12) to mm/dd/yyyy - ...
1
vote
1answer
93 views

How do you format an Excel date to represent >31 days with hours, minutes and seconds

Let's say A1 contains a value which is the number of days in duration. Example: 57.121875 That number represents the number of days. I would like to use an excel format which ultimately makes it ...
-2
votes
1answer
89 views

I am trying to insert a function in my VBA code to only fill a cell when another cell has data in it [duplicate]

This is my code. It fills the Date when I have this =Updating_Date(B5) typed in C5. What it is supposed to do is fill the Date ONLY when data is present in B5, and remove the Date when No data is ...
0
votes
1answer
176 views

How to format Date and Time to display in All Caps?

I am using Linux Mint 17, with the Cinnamon desktop environment. I was hoping there was some way to format the Date and Time to display the Month (abbreviated) and the Day of the week (abbreviated) in ...
0
votes
2answers
63 views

I need a formula to find the last xday of the month [closed]

I am trying to write a formula to find the last Wednesday of each month of the year. I also need the last Friday as well. I am finding ways to get the first Wednesday of a month and tried to modify ...
0
votes
0answers
21 views

graphing the temperature curve of my wood fired oven in excel 2003 [duplicate]

I just finished building a wood fired bread/pizza oven. I have 3 thermocouples installed at 3 different depths in the 7" hearth mass. I have 2 installed in the dome mass. I also get readings on ...
1
vote
1answer
127 views

Why does Windows 7 laptop lose internet connection after I change the system time to the future?

Sometimes when I change the system time on my laptop to the future, then change the time back, I'll lose internet connection with the yellow exclamation point over the internet access systray icon. ...
1
vote
0answers
2k views

How to set system time on Kali linux?

I am trying to set the time, using e.g. date -s "11/20/2003 12:00:00" however, after a few moments, the system time resets to the current time. What am I doing wrong? NTP should not get a ...
0
votes
1answer
531 views

How to display US format date time in csv file in UK format in Excel 2010?

I have a Windows Performance Monitor csv file that I want to view in Excel and produce charts from. The first column in the csv file is in US datetime format. e.g. "01/12/2015 10:54:44.043" which ...
0
votes
1answer
345 views

How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...
0
votes
3answers
339 views

Excel - Recognize JS Date format

I have a service that spits database data out into CSV format, that I can't necessarily change right now. While the executing query returns the standard SQL date format - 2014-12-26 19:41:23.012 - ...
0
votes
2answers
169 views

Linux - set local time without permission

I log into a linux server, which is in an European time zone. How to make my account in an Asian time zone? And I don't have the super user permission. The systems are centos 6.5 and ubuntu 12.10, ...
0
votes
1answer
36 views

Windows 7 time synchronization does not work

I have a strange behaviour when trying to connect to time server on my freshly installed Win7 x64 SP1: First of all, normally you need to pass a UAC check if you want to enter a timeserver, this does ...
0
votes
1answer
250 views

Calculate the difference in hours from now and next workday's 9am

How do I calculate the difference in hours from now and the next workday's 9am? If NOW() is Thursday 6pm and the next workday is Friday, the function would then return 15. If NOW() is Friday 5pm and ...
1
vote
1answer
53 views

Ubuntu thinks I am in Lisbon, Portugal

I installed my first Ubuntu on my laptop last weekend. Whenever I look at the date it is off by several hours. My computer thinks I am in Lisbon, Portugal. How can I fix that?