The tag has no wiki summary.

learn more… | top users | synonyms (1)

2
votes
1answer
501 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
356 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
831 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
27 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 ...
1
vote
4answers
1k 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
126 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
35 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
6k 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
1k 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 ...
2
votes
1answer
1k views

Significance behind January 6 1980 server time [on hold]

Today my iPhone reset its date to Jan 6, 1980. I Googled it and apparently it’s a very common problem. I found a ton of results for January 1980, and most if not all were in January 6th of 1980. The ...
2
votes
3answers
238 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
97 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
146 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 ...
4
votes
1answer
20k 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
242 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
95 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
863 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
152 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
16k 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 ...
0
votes
2answers
68 views

How to Sum Date (in minutes) Shell

I need some help here, I'm not a expert with shell scripting but I am trying to do a script where I need to take the Epoch number followed by the date, but for with the all hours of the day with a ...
0
votes
1answer
181 views

DateTime to just Date

In LibreOffice, Calc under Linux, I have a table with DateTime values (eg. 2011-06-15T15:37:56+00:00). How shall I convert these values to just Date values (eg. 2011-06-15)? I suspect it is very ...
2
votes
3answers
2k views

Excel: show day of week does not work (German locale)

In on cell I'm showing the full date (like 01.01.2013 > German format) and in another cell I want to show only the day of week. So I followed the instructions from Microsoft which refer to the TEXT ...
0
votes
2answers
2k views

Archlinux wrong localtime

Here is datetimectl output, Why local time is not set to Universal time? And I have enable ntpd service. The local time should be Sun 2013-08-11 21:45:21 UTC. Local time: Mon 2013-08-12 ...
3
votes
1answer
2k views

Windows 7 Explorer Columns: meaning of “Date” in relation to “Date Modified”/“Date Created”?

I've managed to alter the creation/modified date on a large number of files that I've moved with a well known 3rd party software. The only field that seems to point to a valid period of time is ...
1
vote
1answer
2k views

Why does Excel treat some dates differently than others?

I have a CSV file that contains strings meant to be interpreted as dates with minutes, seconds and miliseconds. In particular entries look like this: "07/31/2013 23:59:32.864",otherdata,moredata ...
0
votes
1answer
1k views

Excel: Third Wednesday of a month

I need to get the next IMM date after a date. IMM dates are defined as the third Wednesday of every March/June/September/December.
3
votes
0answers
117 views

Why does Windows Explorer display a bogus updated time, and is there a way to recalibrate its datetimostat?

Here is my process when testing a Windows CE app: Rebuild it to create new .exe/.dll pairs from the two projects in the solution (PDAClient.exe and HUtilCE.dll). Since I have to do this development ...
0
votes
1answer
422 views

I neet to convert date value into date/time value in a cell

I have a cell with 07/26/13 and I want a formula to take this date each day it is updated and convert it to 07/26/13 00:00, so that I can make a formula in another cell with a time reference of IF ...
1
vote
1answer
2k views

Automatically insert time/date last modified into notepad++

How do I automatically insert the time & date last modified into a Notepad++ document? I have found a question about automatically inserting the current time, but it appears to be about a much ...
0
votes
0answers
238 views

In MS Excel cell format, How to change the default time duration from “number of days” to “number of minutes”?

In MS excel if I set a cell format as time (e.g. [h]:mm:ss) and then if I type any number N in that cell, MS excel assume that number as number of days since 1st Jan 1900 00:00:00. Is it possible to ...
2
votes
1answer
1k views

How to “batch-convert” all date/times in a cell range to strings?

(Note: This SO question is similar, but I'm interested in solutions that are more scalable. Hence the "batch-convert" in the title. Also, I originally posted this question to StackOverflow, but then ...
0
votes
1answer
873 views

If I change my computers date / time, what could be affected? [closed]

I have recently come across a couple of games that trigger certain events only at certain times and/or dates (Superbrothers Sword & Sworcery, and FEZ). If I want for such events to happen, I ...
1
vote
4answers
2k views

How to calculate age in years?

In Excel 2010, I'm using the formula =(TODAY() - 05/31/1996) / 365.25 to calculate the age in years between today's date, May 30, 2013, and May 31, 1996. I'm expecting some number close to 17.00, but ...
1
vote
1answer
555 views

How to make Lotus Notes 9 display post time in inbox?

When I receive mail from an internet mail server, all incoming mail is displayed with the date/time of the replication. How can I change this? I would like to have the date/time visible in the inbox ...
2
votes
1answer
173 views

linux diff: is there a way to list differences by when the files were last modified?

In the Linux terminal, I'm using diff --recursive --brief dir1 dir2 A couple of weeks ago, dir1 and dir2 were identical, but they have both been modified since then. I would like to order to ...
1
vote
1answer
338 views

How to display normal date-time in Midnight Commander?

My MC displays modification date time in very strange manner. Sometimes it displays date+year and sometimes it displays date+time. Unpredictable. How to make it display something predictable? ...
3
votes
1answer
61 views

Linux History Display Dates

I added date and time to my linux history with this command: export HISTTIMEFORMAT='%F %T ' When I actually go to view my history anything that I didn't actually do today seems to pick a time that ...
0
votes
1answer
53 views

Excel sorting Server Access logs using dd/month/yyyy

I am collating my server access logs to get a cumulative count of HTTP requests made to the server over a period of a few months. Access is logged as a date time stamp like so: ...
0
votes
1answer
582 views

Data time not present in photos transferred to PC from Lumix TZ11

I have a Lumix TZ11 camera. My problem is: the photos transferred to PC from camera DO NOT contain the date/time stamp of the photos taken. However, when viewed in the camera, I can see the date/time ...
0
votes
1answer
239 views

Does Windows have a standard enumeration of world timezones?

I want to store a date and time in an application where compactness is paramount. As well as the datetime, I want to save the associated timezone. While I could just store the timezone bias -i.e. a ...
0
votes
1answer
1k views

How to change date and time of a remote computer

How to change date and time of a remote computer that runs windows XP on a 2008 domain? because that client failed to log on local or from remote desktop with below message:
2
votes
2answers
519 views

Is this the best strategy for displaying a negative time value in Excel?

I am trying to send up a calculated cell as duedate - now() in order to quantify overdue vs. time remaining (negative values = overdue, positive values = time remaining). Consider: Col A ...
0
votes
1answer
193 views

Excel date formatting after formula calculation

Say I have the following two dates in column 1 of my spreadsheet: Tuesday, February 12, 2013 10:13 AM 2/12/2013 10:13 When I highlight the column and change the cell formatting to a date type of ...
1
vote
1answer
118 views

Understanding time synchronization in Linux

My /etc/localtime on my Ubuntu gives my correct timezone - EAT which is UTC +3. The date command gives the time as 21:44:58 EAT which is about the correct time (I'm not concerned about accuracy to the ...
0
votes
1answer
2k views

Change system data with deepfreeze

I have a mother board with broken BIOS. My time change every time I turn on my computer, even I change the CMOS battery, still won’t save my setting. For able to work on some games and application, I ...
2
votes
2answers
13k views

Calculating a duration in excel from date and time

I have 2 columns in excel, each column includes a date and a time in the following format: 'dd/mm/yyyy hh:mm'. One is a start date/time, the other is an end date/time. The end date/time could be ...
0
votes
2answers
891 views

I need a VB script that executes to update Time Server every time Windows starts up

I need the script to automate Time Server update. I suspect the internal battery that keeps time up-to-date is dead and I don't want to change the battery because I'll discard the laptop soon for a ...
0
votes
1answer
3k views

In Dropbox, how can I tell the date and time when a file was shared?

I have shared a directory (folder) with another Dropbox user. Over the course of several weeks, this user has shared a number of files with me. I need to determine the date and time when these files ...
5
votes
2answers
33k views

Using Date and Times in a batch file to create a file name

I am running a program from a batch file, which when it is done performs an automatic backup of my MySQL database. I would like the batch file to create a different back up for each run, so I can ...
1
vote
3answers
10k views

In Excel 2010 why can't I change the date format?

The original date is in the following format: 14/Nov/201110:53:44 I need it in this form: 14.11.2011 10:53:44 When I choose Number -> Custom -> d.m.yyyy h:mm -> OK , nothing changes. ...