The date-time tag has no wiki summary.
0
votes
3answers
42 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
2answers
67 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
44 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
51 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 ...
1
vote
3answers
63 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
79 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
0answers
32 views
Copying single files into a folder that changes name every time the batch file is executed
Can you please help, I am using this to put the text files made by the batch file into the folder created by the batch file as well. but my problem is that the name is changed of the new folder every ...
0
votes
1answer
51 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 ...
0
votes
1answer
117 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
78 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
101 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
358 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?
1
vote
2answers
197 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
78 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
118 views
Windows 7: How to display both date and time in tray *without* using large icons or increasing the height of taskbar? [closed]
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
109 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
411 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 ...
0
votes
2answers
286 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
895 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 ...
0
votes
0answers
68 views
Compare “Date” field in Oracle [closed]
I have 2 questions:
I want to compare a field whose data type is "Date" against a given date.
The DB is oracle and being a mysql guy I'm finding it difficult to come up with simple queries.
The ...
1
vote
2answers
176 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
101 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
108 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
310 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
249 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
258 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
597 views
Can I Set My Computer's Clock Display To 24-Hour Format? [closed]
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 ...
2
votes
1answer
659 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
306 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.
1
vote
1answer
386 views
Why do my Windows Date and Time Format Settings impact the default Language for Applications?
This behavior has been bugging me for ages. I live in Germany but I prefer my operating system and all installed applications to be in English.
So whenever I install a Windows system of mine, I ...
2
votes
1answer
2k views
Internet Time tab has disappeared from the Date and Time applet of the Control Panel
Previously, there was an Internet Time tab on the Date and Time applet of the Control Panel, wherein one could force a query of an internet time server and also type in a different server from the ...
1
vote
1answer
240 views
Sync Windows' system time to a time server, but advance by 10 minutes from the time server's time
Is there a software or a way to configure Windows 7 such that I could sync the time to a time server, but have my system's clock advanced by 10 minutes from the time server's time?
E.g. When ...
2
votes
1answer
176 views
Who was the last modifier of a file on a mapped network drive?
I am running Windows 7, and I have a mapped network drive. Is there any way to examine a file on that drive and find out who was the last user who modified it? If so, how can I do this?
0
votes
0answers
133 views
Is weak bios battery will cause system date to change but not the time?
I was wondering on how did the bios system date change to a week ago while the system time was not affected and still the same as well as the time zone config. Was this cause by the bios battery is ...
2
votes
1answer
229 views
Slow connection and NTP
I'm behind a slow connection (Dial Up) with high latency (+400ms). I have recently received a broken MyBook World, which I refurbished and I have Debian installed on it.
The problem is, that this ...
3
votes
2answers
565 views
Insert current week number in Microsoft Word
Is there any way in MS Word to insert current week number? I need to make a template for the weekly report, and I'd like the week number field to be filled in automatically... What I need is something ...
1
vote
1answer
2k views
Auto Sync Windows XP time on Boot
I have an old PC with a defective CMOS battery, and every time the clock is reset, I have to log as admin in Windows XP and set the date manually, then I can sync from the server.
As this computer has ...
2
votes
5answers
188 views
Converting date format in formulas in Excel
what is the formula which would enable me to calculate the difference between 2 dates and 2 times? Example: In the same cell, I have 01 January 2005 07:30 and in a second cell i would have 06 January ...
0
votes
1answer
520 views
How do I specify a date range for find command on OSX?
I need to find files within a date range to the minute. I suppose knowing how to do it to the second might be beneficial one day. Anyhow. I've learned how to use -newermt and even -not -newermt; ...
1
vote
0answers
32 views
Time Zone Value: N/D?
When reviewing the output of the set command in Windows XP, I noticed a time zone value of "N/D". What does this mean? Not Defined? No Data?
Why would this happen?
-M
2
votes
2answers
247 views
What date formats does Excel recognize as dates?
What date formats will Excel recognize as dates?
I've been using Jul 30/10 11:41:10 but Excel doesn't recognize this as a date.
I don't want to apply a function to the value, I just want to open ...
0
votes
2answers
610 views
Alternative ways to check time zone in Windows XP?
Windows XP
Hi guys,
Is there a way to verify a user's configured time zone from the command-line? I'm trying to help a third-party user with a time related issue and they don't have access to their ...
3
votes
2answers
102 views
Clock set to year 2028
The date on my Windows 7 x64 PC has twice been set to the year 2028, which causes all sorts of stuff to stop working (website certs, TV guide listings, virus definition updates, etc). Any idea what ...
1
vote
2answers
986 views
EXCEL: How can you FORMAT a serial number into a MONTH ( Jan, Feb)
I extract the Month() number out of my date. I now want to change that number into a recognisable string Jan, Feb, Mar, etc. In Access you can use FORMAT, but what can we use in Excel?
E.g.
...
1
vote
1answer
311 views
Change the starting day in Vista's Calendar Gadget
I have a problem with the calendar gadget in Vista. The starting day is Sunday, but I would like to change it to Monday.
I have checked some forums which points me in the direction that:
Change the ...
1
vote
2answers
586 views
SQL Server Management Studio Express - include date/time in Results or Messages
In SQL Server Management Studio Express 2005 is it possible to output the date and time that a query completed in the Results or Messages windows?
(without having to manually add a SELECT Getdate() ...
2
votes
1answer
192 views
Set ubuntu locale
How can I set my locale and date format to be y/m/d in Arabic?
Machine Info: Ubuntu 9.10
2
votes
1answer
2k views
Desktop clock widget or application for several places
... i.e. I need a little clock application which floats on the desktop, and shows time. Only I need several clocks (three to be exact) for 3 time zones.
Anyone know of such an app?
1
vote
1answer
1k views
Excel: Summing values within a certain date range (> start date and < Finish date)
How do I include a 'Between these dates' criteria inside a SUMPRODUCT?
=Sumproduct((RangeName=Cell A1)*(RangeDate=Between 01/03/10 and 31/03/10)*(RangeCost))
What's the way to manage dates ...
2
votes
1answer
376 views
Excel: ROUND & MOD giving me strange DATE results
This is sort of related to a previous question. My formula, which seemed to work fine yesterday now gives strange results.
Today is the 30th of March (30/03/10). It's 10:11am on the clock that the ...
