The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
0answers
120 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
34 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 ...
1
vote
1answer
1k 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
231 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
96 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
141 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
17k 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
232 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
90 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
808 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
149 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
15k 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
175 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
411 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
235 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
829 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
536 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
163 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
323 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
60 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
561 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
227 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
509 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
185 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
116 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
856 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
31k 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
9k 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
166 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 ...
5
votes
2answers
997 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
511 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
198 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 ...