The date-time tag has no wiki summary.
0
votes
1answer
15 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
18 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
47 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
183 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
1answer
129 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
42 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
55 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
0answers
49 views
Time truncation in database results in Excel 2013
We have an application built upon Excel (some querytables plus some VBA).
Behind that is an SQL Server query that returns some dates, date part of which is 1899-31-12. This date value is the "zero ...
0
votes
1answer
269 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
169 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
173 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
204 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 ...
3
votes
1answer
979 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
1k 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
90 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
2k 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 ...
1
vote
1answer
199 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
145 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
85 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 ...
0
votes
1answer
99 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
141 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
169 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
0answers
36 views
OpenOffice Date calculations
If Notice to vacate is given on any day of a month, say Jan 3rd result to return last day of the tenancy as the last day of the following month factoring in leap years.
other
If tenancy starts on ...
0
votes
3answers
727 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
2k 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
396 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
786 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
938 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
306 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
148 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 ...
1
vote
2answers
2k views
My system clock is an extra (extra) hour ahead during BST/ daylight saving
I have a problem when my Windows 7 64-bit laptop is used during BST (British Summer Time)/ daylight saving periods.
Instead of the +1 shift in time, the system clock shifts +2 hours and can be a few ...
0
votes
1answer
518 views
System time wrong after running ntpdate because DST ignored
When I run ntpdate, my system clock displays the time as an hour behind what it should be. I know that ntpdate does everything in UTC, so I'm guessing there's a timezone setting wrong and it's ...
0
votes
1answer
283 views
excel time difference if a cell is not formatted as time
I just can't solve this!
Excel 2010, I have a timesheet where I write day by day the entry time, exit time, lunch time.
A cell computes the worked hours, say:
A B C D
entry ...
1
vote
1answer
2k views
How do I remotely set the timezone and daylight savings time settings of Windows domain computers?
How can I remotely control/change timezone and Daylight Savings Time (DST) settings of Windows domain computers?
2
votes
3answers
953 views
Force date/time/clock sync
My Snow Leopard macbook is set to Set date and time automatically: Apple Americas/U.S. (time.apple.com), but despite sitting idle for several hours (with internet connection), it has yet to do any ...
2
votes
1answer
151 views
How do I create 7z files by date
How do I create a 7z file that had only files created after a specified date in it, using the command line?
0
votes
1answer
1k views
Windows 7: How to display both date and time in tray *without* using large icons or increasing the height of taskbar? [duplicate]
Possible Duplicate:
Windows 7 - display date using small icons
As we approach the year 2012, there has to be a way to show the date and time in Windows 7 without doing any of the following:
...
0
votes
0answers
212 views
Change system time and turn off Internet time in Debian/Gnome
Changing the time is easy, but then it is automatically synchronized with a time-server.
Before I had access to admin menus, but now I don't, when I click on the clock and try to change, i get an ...
1
vote
1answer
1k views
Why can't Kleopatra (gpg4win) import my freshly-created key from another PC?
I just created two new GnuPG keys on my linux box and then tried to import the public keys on my Windows 7 machine running gpg4win 2.1.0 with Kleopatra. However, I always get the message
Insgesamt ...
-1
votes
2answers
1k views
Excel conditional formatting comparing date and time to current date and time
I have a style sheet in which I have to dates with times
-----------------
29/09/2011 12:00
29/09/2011 14:00
-----------------
If current date and time is 29/09/2011 11:50 then row is green
If ...
2
votes
3answers
5k views
Custom Date Format in MS Word 2010
I have a date field in a Word document which was created from a template included with Microsoft Word 2010. The default setting for this field is to display only two places of the current year.
I ...
1
vote
2answers
479 views
Why is there a date in my Excel time format, and how do I get rid of it?
I am using Excel at work and I have a list of users' online times.
I get a total say 180:30:00, which is 180hrs 30 mins and 0 seconds.
I need to keep this cell as the time, but I want to work out ...
0
votes
1answer
478 views
How to import row data into Access when Excel does a date conversion?
I have an Excel worksheet that looks like this:
MONTH WIDGET QUANTITY COST
Jul-09 Widget1 1000 1.00
... <repeat a few thousand times> ...
I would like to ...
0
votes
0answers
177 views
Applet to copy current date+time as YYYY-MM-DD HH:MM to clipboard?
I sometimes need to type the current date + time in MySQL format, ie. YYYY-MM-DD HH:MM.
Before I write one myself, does someone know of a Windows applet that does this, so I could just double-click ...
0
votes
2answers
689 views
Generating a timestamp to usec accuracy in shell (Busybox)
I want to generate a textual timestamp in the unix shell with microsecond accuracy, without using the %N date option (I am using busybox, a smaller unix toolset that does not have this option), to ...
1
vote
3answers
841 views
Date goes back to 2005 after restart
The date to my computer goes back to 2005 after every restart, what could be the problem?
I have checked the CMOS battery and it is working fine.
OS is Windows XP.
2
votes
2answers
730 views
Bash: number of seconds till midnight of current day
How do I find the number of seconds till midnight of current day?
0
votes
1answer
2k views
Can I Set My Computer's Clock Display To 24-Hour Format? [duplicate]
Possible Duplicate:
Can the Windows clock be configured to display a 24-hour-based time?
The title pretty much says it here. I'm just wondering, is it possible to switch my Windows 7 ...
3
votes
1answer
2k views
Converting Unix Time into Human Readable Format in Excel
I have a spreadsheet containing several timestamp columns, given in Unix time, i.e. number of seconds since 01/01/1970 00:00.00 UTC.
Using Excel 2010, are there any methods, and if so how, to ...
0
votes
2answers
866 views
Searching for files which was created at certain date
Is it possible to find files which was created at certain date? I don't remember file name, but I know date when it was created. I am using windows 7.
