The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
0answers
9 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 ...
0
votes
0answers
21 views

How can I set 24 hour time in KDE5

It seems the new way is 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 ...
1
vote
0answers
117 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
11 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
92 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
39 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
-1
votes
1answer
44 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
38 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
19 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
117 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
29 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
28 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
52 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
41 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
39 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
48 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
44 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
47 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
20 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
94 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. ...
0
votes
0answers
592 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
260 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
164 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
179 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
98 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
0answers
19 views

Windows 8.1 Time keeps jumping around [duplicate]

So for some reason, my time keeps jumping 6+ hours into the future when I boot to Windows 8.1. I'm dual booting Debian and Windows. My BIOS time is always correct though... quite confused. Time zone ...
0
votes
1answer
29 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
162 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
48 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?
0
votes
3answers
2k views

Excel VBA or Formula to convert text to Date with Time type

I have a quite a number of data where its date/timestamp has been imported into excel as text. Excel does not really recognize it as date with time. e.g. 25.08.2011 16:17:59 (mm.dd.yyyy hh:mm:ss) ...
0
votes
0answers
258 views

Setting my computer to the correct date and time stops website security certificates from validating

I recently got a new computer and I've come across a peculiar issue related to internet security certificates and setting my time in Windows. Here is my sequence of events thus far: Booted new ...
0
votes
2answers
32 views

What happens on the OS when the user changes the date/time? [closed]

I'm just curious about a question: let's say we have a folder containing some very important files (could be the System32 directory). We know that the filesystem stores some information about their ...
-1
votes
1answer
179 views

Is it possible to slow down system clock? [duplicate]

I'm playing a game that is using JavaScript to get system time, and I need the best time in the game I can get, I tried Cheat Engine but, as I said game uses JavaScript, so it is of no help to me. I ...
0
votes
0answers
20 views

Prepend text for spreadsheet

I want to have a string value prepended to a XL-style formating in a spreadsheet program (gnumeric). The current formatting is [$-f4f2]hh:mm which should take 1:00 PM as input and convert/display it ...
0
votes
1answer
95 views

How to make Excel treat days/dates as starting at 8 p.m. rather than 12 a.m

Our 24-hour day is 8PM to 7:59PM. That's considered 1 day, not 12AM to 11:59PM. For times after 8PM, I need the entries to be considered part of the next day. For example: Actual Date/Time ...
0
votes
1answer
85 views

Server (Win2008) has correct time, but all workstations (Win7) are ahead one hour

Thanks for reading. The network in question has one DC, which is a Windows 2008 R2 Server. All workstations are Windows 7 Pro. This last Monday (9/22) I noticed the time was suddenly ahead by an ...
0
votes
0answers
32 views

How can I know when the system time was updated in linux?

In linux is the system date/time and other date related details like timezone stored in any file where I can view the updated time and know when the system time was last updated. Is there any other ...
0
votes
0answers
52 views

Time desklet with time zone different than system timezone in linux

I want two desklets on my desktop, one showing system clock's time and other showing time at a different time zone. I tried searching for such a desklet where I can configure its time zone but ...
0
votes
1answer
196 views

Timestamp in Excel…not working?

I know this question has been asked numerous times, and I have truly searched and attempted to work it out with the given solutions to no avail. Maybe I'm doing something wrong, but I don't know much ...
1
vote
2answers
798 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
0
votes
1answer
89 views

Financial Quarters from date

I have looked around for other solutions to this issue using the =ROUNDUP(MONTH(A1)/3,0) code. However I am not using the standard dates for Quarters Q1 - 02-Feb/03-may Q2 - 04-May/02-Aug Q3 - ...
0
votes
0answers
61 views

How to set default date time format in OpenOffice Writer?

How to set default date time format in OpenOffice Writer? It does not obey locale setting in Tools -- Options -- Language Settings -- Languages for me. Locale is set to Russian, while date-time ...
1
vote
3answers
457 views

Excel date & time formula-round up cell value

I'm preparing a report of usage statistics for a group study room reservation system we use at the library where I work. I've exported all the reservations from MySQL in Excel for the past year and am ...
0
votes
0answers
358 views

batch file-change date back, run program, stop program, change to actual date

please for special purpose I need for one program to run it on system date 06.04.2014 what is batch file to automate it, that is change system date back, run program (i want work in it maximum 15 ...
1
vote
3answers
3k views

Calculate number of Sundays in the month

In Microsoft Excel I am looking to determine the number of Sundays in any given month. I am putting together a budget spreadsheet and some of the sub accounts get extra funding when five Sundays are ...
2
votes
1answer
63 views

Is there a way to paste a date into a Chrome date field?

When filling in a form in Chrome, HTML5 forms have a nifty date field nowadays which Chrome renders a rather helpful date picker. This is nice unless you have loads of forms to fill in. I'd like to ...
2
votes
1answer
586 views

How much clock drift is considered normal for a non-networked windows 7 PC?

I have a stand-alone PC with no network connection running Windows 7 (64bit) and the system clock loses about 1 minute per week. Is this level of drift considered "normal" or is it a dodgy RTC or a ...
2
votes
1answer
253 views

Powershell LastWriteTime is incorrect

I am running the following script to create directories based on the first 9 characters in the filenames in the directory and then moving te files into these directories based on their filenames. dir ...
0
votes
1answer
195 views

LibreOffice Calc time formatting trouble

I'm calculating a time sheet with LibreOffice with this SUM column. 00:00 08:00 08:00 08:00 08:00 08:00 00:00 04:00:00 PM The printing format of the bottom row is Time 876613:37:46 but that's not ...