The tag has no wiki summary.

learn more… | top users | synonyms (1)

0
votes
0answers
11 views

LibreOffice Calc time formatting trouble

So 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 ...
0
votes
1answer
22 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
21 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
35 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
48 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
27 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: ...
2
votes
2answers
50 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
40 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
56 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
33 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
33 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
41 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
102 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
16 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
1answer
48 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
40 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
13 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
284 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
274 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
159 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
80 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
38 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
74 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 ...
0
votes
1answer
153 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
106 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
58 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 ...
1
vote
1answer
152 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
89 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
1
vote
1answer
1k 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
53 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
94 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
723 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
899 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 ...
0
votes
0answers
68 views

How can I determine if system date is changed in windows server 2003?

I'm a programmer and I'm really new to server administration. Is there any way to find out if some one has changed the system date in Windows Server 2003 R2? Does Windows Event Log help?
2
votes
1answer
622 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
633 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
321 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
94 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
185 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
939 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
126 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
369 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
435 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
285 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 ...
0
votes
1answer
214 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 ...
1
vote
1answer
87 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 ...
0
votes
0answers
129 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
45 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
43 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
217 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 ...