The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
1answer
74 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
675 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
138 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
10k 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
66 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
145 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
1k 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
912 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
115 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
336 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
210 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
879 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
730 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
1k 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
476 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
145 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
270 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
53 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
51 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
507 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
197 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
449 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
156 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
112 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
9k 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
733 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
2k 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
1answer
24k 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
8k 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. ...
1
vote
1answer
161 views

Gnome clock applet, where's the data stored?

I mean, when I type location it gets GMT +/- fixes, were does that information come from?
0
votes
1answer
3k views

Windows 8 Date and Time Sync Issues

I have an Asrock Z77-EXTREME4-M motherboard and use Windows 8 retail. The system clock is always wrong on boot and it seems to be off by however long it was since last boot. I.e. if I turn the ...
3
votes
1answer
901 views

How can I batch shift the creation date of files on OS X 10.6.8?

Please note that I am not asking how to change the creation date of a bunch of files to a given date. I want to shift the date by a given amount of time, for example 47732400 seconds. Can I ...
3
votes
1answer
468 views

Ubuntu server loses exactly 5 minutes once in a while

I noticed that my server, an Ubuntu server 12.04, was losing time. I figured the hardware clock was off or maybe dying due to a faulty CMOS battery. I installed NTP to ensure the drift would be ...
1
vote
1answer
175 views

Excel Date Formula with a condition

I have 3 fields in excel as follows: Cell A1=2012 A2=12 A3=15 which contains year, month & date value respectively. And I want to make a date string out of it. I know it's very easy to achieve ...
1
vote
1answer
283 views

Identify date/time format

I've been given some data to create some chart graphics and the dates are in a format I don't recognise. If I knew the format name I could easily look them up but initial search has drawn a blank. ...
1
vote
1answer
632 views

Need a formula that generates a new time that is a random interval from the last time but between 25 and 30 mins [closed]

I am using Excel to try to come up with a schedule for when I will be doing my rounds. I have to do them wwithin thirty (30) minutes from the last time and I don't want to go less than 25 minutes ...
1
vote
1answer
434 views

Replacing 12 hour format date and time in Notepad++

I'm trying to remove the date / time stamp from text in the following format: Randomtext - randomtext 9 Aug 5:55am 2nd line of random text - 2nd randomtext 15 ...
0
votes
3answers
1k views

How can I compare Excel serial dates WITHOUT converting to mm/dd/yy type dates?

I have a table that contains a number of values representing Excel serial dates. After a number of unsuccessful attempts to compare fields, my current approach is to do comparisons between serial ...
2
votes
3answers
4k views

How do I `SUM` by multiple columns in Excel

I have a comma delimited file that includes two columns date/time (which imports as Excel's mm/dd/yyyy hh:mm custom format) and status of 1 or 0. The status represents a piece of equipment either ...
4
votes
1answer
745 views

Is there a clock application with deciseconds (HH:MM:SS.d)?

You may wonder, But I am interested in a clock app that in addition to second show decisecond. I deeply searched and could not find one yet, did you know any app (desktop gadget/system tray clock) ...
0
votes
2answers
1k views

cmd: include date and time to filename

How can I get a filename YYYY.MM.DD_HH.MM.SS.7z? It should work with any regional settings! The question is not duplicating 7zip CMD: Add current date to archive & include only last modified ...
2
votes
4answers
6k views

How do I calculate number of hours > 24 in Excel?

I've got an excerpt of my spreadsheet below. It's a time tracking application containing a start date/day, a session ID and the duration of the session. Column A is populated by adding the duration in ...
0
votes
1answer
525 views

Time is getting reset to old value in CentOS 6.2

I have installed CentOS 6.2 in a VM on ESX & whenever I change the time to the appropriate value using date & hwclock command it's getting changed for that session. Once I restart the instance ...
0
votes
1answer
204 views

re-format date insert by “CTRL ;” in excel

In excel, we can insert date using "CTRL ;" shortcut, but the date inserted are in "M/d/yyyy" format. I want to insert date in the "d-MMM-yy" format them I've re-config the Region and language as ...