The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
34 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
43 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
62 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
34 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
30 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
49 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
9 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
55 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
35 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
24 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
21 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
54 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
145 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
35 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
24 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
176 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
144 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 ...
0
votes
2answers
565 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 ...
1
vote
1answer
32 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 ...
0
votes
0answers
110 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
159 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
89 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 ...
0
votes
1answer
472 views

Excel date time find max / min and max min timespan

I have data time data in excel in the format "04/18/2014 17:09:09". I would like to use MAX and MIN on a range of such dates to get max, min and time span between min-max. I tried using custom format ...
1
vote
1answer
39 views

Can I change the date format only in the taskbar

Can I change the display format just for the date in the windows taskbar? I know that you can customize the format of the date in the taskbar by changing the "short date" display format in ...
1
vote
2answers
729 views

How to i convert a date entered as dd-mm-yy or dd-mm-yyyy to excel date

I have a sheet with date column entered as dd/mm/yyyy eg 15/12/2014 However excel does not treat this as a date ,hence I cannot apply any date functions to this column . Is there a way to convert ...
0
votes
2answers
169 views

How does Daylight Saving Time work on a computer?

I was wondering does the computer's time chip itself update the time, even when the computer is turned off (for example, the BIOS or OS send a command that when you reach a certain time you go ...
0
votes
2answers
46 views

Time stamping of files in Windows 8

I need to know the exact time I shot a video. The video was shot with an iPhone and moved to a Windows 8 PC. The Properties dialog in Windows tells me the following about this file: Created: ...
3
votes
4answers
2k views

Windows 8 date format dd/mm/yyyy

Is it possible to change the date format for windows 8 to be dd/mm/yyyy with the separator being specifically (/)? Is the only way to do it in the registry? Start program regedit.exe (via Win+R and ...
0
votes
1answer
977 views

How to prevent Excel to use the OS regional settings for date patterns in formulas

According to this question I have the following problem: I want to use some Excel function (not the cell formatting) like TEXT(A1, {date_pattern}) But the person who answer my previous question make ...
1
vote
1answer
677 views

Creating a zip file with a timestamp

I have been trying to create a script which compresses a directory with a timestamp and move it to another location on the same server, but I cant seem to get TESTDATE to display on the zip file, ...
1
vote
1answer
373 views

Libreoffice: format field yyyymmdd to date

How can I format a field value like 20140226 to 2014-02-26 in LibreOffice? If I use the format cell option I get strange values.
0
votes
1answer
296 views

Generate event distribution chart in Excel

I have a single column in Excel with lots of date/time stamps (in UTC) of certain events, like this: 2014-02-20 23:04:57.9263690 +00:00 2014-02-20 23:05:02.3117944 +00:00 2014-02-20 23:05:02.7490564 ...
0
votes
1answer
208 views

How can I set the gnome date/time from the cli?

Our network (Debian wheezy server and clients) use Kerberos for authentication, and one of its great features is that there should not be timedifference between the ticketserver and client - otherwise ...
1
vote
2answers
536 views

Setting Time in Lubuntu

I have a time server running on a server PC that is meant to change the times of various guest PCs as a result of a TCP/IP command on port 9000 issued by a control application running on an integrated ...
0
votes
1answer
24 views

How to show time zone in display time on Windows

I'm using an editor that can insert date time values into files. It uses Windows (mostly 7 and 8.1, in my current use) as the source of the timedate string. I'd like to use ISO 8601 style date ...
0
votes
4answers
617 views

Mac OSX Numbers - Convert text to datetime

I am using Numbers on a Mac. I have a CSV file which contains numerous dates in the format MM/DD/YYYY. I need to convert these dates into datetime format for insertion into a MySQL table. How do I ...
0
votes
0answers
92 views

Using Excel to calculate time differences with blank cells and calculate monthly totals

I have a sheet that looks like this: Level 1 Level 2 OFF Date Time Date Time Date Time Total T Total L2 12/3/2013 12:50 ...
0
votes
0answers
26 views

Cant change date and time in Fedora19

I am using Fedora 19. The problem is that i want to change the date and time in my system and for that i clicked on the date and time settings. But the window does not appear. Similarly, I cant change ...
0
votes
1answer
4k views

Word 2013: Shortcut to insert timestamp into word document

I'm looking for a very very fast method to insert a timestamp into a Word document. I always know the shortcuts ShiftAltD and ShiftAltT, but doing so inserts a field, that is always automatically ...
1
vote
4answers
865 views

Converting text date into standard date format in Excel 2010

I've got an Excel 2010 spreadsheet that has a large number of dates for the year 2014 entered in the following format: Thursday 24th July that I need to convert into standard date time format (the end ...
1
vote
1answer
920 views

Significance behind January 6 1980 server time

Today my iPhone reset it's date to Jan. 6 1980... I googled it and apparently it's a very common problem (A ton of results for January 1980... Most if not all were in January 6th of 1980)... the ...
2
votes
3answers
165 views

How to make excel return a date from a column corresponding to the last 'YES' in a different column

I'm trying to develop a spreadsheet tool to help track the training currencies of professional aircrew. In order to be considered 'current' in all training, aviators must accomplish a variety of ...
0
votes
1answer
91 views

Create script to login and change time on unix Darwin

I work for a non-profit and recently had to take on some sysadmin responsibilities, and and it is a new area for me. We have a Apple X Server that is running Darwin, and from time to time, especially ...
1
vote
0answers
112 views

Calculating duration of event overlaps in Excel. How? [closed]

I have a long list of events with start and end times. I need to calculate the amount of time that a number of events or more are happening simultaneously (e.g. the amount of time that X or more ...
2
votes
1answer
6k views

How to concatenate a date in MS-excel and receive a date (not a number)

When I try to concatenate two cells in MS-excel in the formula I have the date as a integer number (eg: 04 april 2012 become 41006). How can I display the date also in the formula cells?
0
votes
2answers
178 views

Excel VBA Right Function Error

I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error ...
0
votes
1answer
70 views

vlookup datetime FALSE; return value from 1 of two columns based on exact datetime

Based on data below, I am trying to do a vlookup such that if the datetime in ends in 18:59 return the value in column_3, if the datetime ends in 6:59 return the value in column_4... 10/7/2013 18:59 ...
2
votes
1answer
627 views

Windows Event Log SystemTime format

The follwing timestamp was created during an Windows Security Log TimeCreated [ SystemTime] 2013-10-07T07:31:09.122037600Z In this timestamp I can't understand what 122037600Z part means? Do ...
0
votes
1answer
135 views

Convert datetime to another datetime format

How do I convert this datetime? [23/Sep/2013:21:18:00 +0200] to 23/Sep/2013 21:18:00
2
votes
1answer
9k views

Formula to add minutes to date+time in Excel

If I have a cell formatted as date+time in Excel, how can I add to this in terms of minutes? It would need to work whether I was adding 20 minutes, or 2,500 minutes. So, for example if I had this ...