The date-time tag has no wiki summary.
0
votes
1answer
48 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
73 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
101 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
43 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
40 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
58 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 ...
0
votes
1answer
171 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
101 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
2answers
359 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
28 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
114 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
58 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
79 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
204 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
174 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.
1
vote
2answers
169 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
394 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 ...
1
vote
1answer
385 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
211 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
280 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 ...
1
vote
0answers
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
198 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
117 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
120 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
191 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
1answer
405 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 ...
0
votes
1answer
1k 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
168 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
420 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
30 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
174 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
385 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
92 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
711 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
282 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
528 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
156 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
1k 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
768 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
341 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 ...
3
votes
1answer
489 views
Excel 2007 - How can I write “use this cell” or IF BLANK “use this cell”?
I am trying to show the Days between NOW() and the dates (dd/mm/yy) in, either Column B or Column C - depending which one is NOT blank
A B C
29/03/10 01/04/10
29/03/10 ...
1
vote
1answer
134 views
How to keep windows 2003 Daylight Saving values updated
My web app runs on windows 2003 .Net 3.5
I have users from Israel (GMT +2), and Israel switched to Daylight saving time on 26/3/10 so now it's (GMT +3).
I use TimeZoneInfo.ConvertTime that doesn’t ...
6
votes
4answers
4k views
Change default calendar starting weekday in Windows XP
In the "Date and Time Properties" dialog of Windows XP (reachable by double-clicking on the time/date on the taskbar) the week in the calendar starts on Monday. I would like to change it so that it ...
4
votes
1answer
187 views
Windows 7: System date and time resets to 2007
My desktop computer has been upgraded to Windows 7 and ever since whenever I start it up, it resets the date and time to 2007. I tried changing the battery on the motherboard thinking that it would ...
0
votes
1answer
599 views
Vista: “Change date and time” causes permissions error
I double-click on the time in the bottom right to open the date and time panel. Then I click on the "Change date and time..." button (which has a shield) and I get the UAC dialog. I click "Continue", ...
2
votes
1answer
41 views
Windows App-specific dates and browser certificates
In Windows 7 I can set a "per program" sound setting. It's cool, because I can mute the browser (by example) and listen music without a lot of "noise" from another open windows.
Now, I need a "per ...
2
votes
3answers
517 views
Customise date-time format in Windows
Is it possible to customize data (or date-time) format in Windows [I am using windows XP]?
The current format which is followed by the OS [to show date-modified, etc.] is MM/DD/YYYY or M/D/YYYY, ...
1
vote
2answers
99 views
Free portable lightweight app to see time in selected cities, including daylight savings
I want some recommendations on some free portable lightweight app to see time in selected cities, including daylight savings.
I currently use a Firefox plugin but I want to free it from this so I ...
3
votes
3answers
5k views
Windows 7, file properties, date modified, how do you show seconds?
Anyone know a way to immediately show the seconds of a file's date modified property in the GUI? So if you create a file, any file in any directory, right-click and choose Properties, the date ...
2
votes
1answer
384 views
How do I create a custom date format in footer that updates automatically in Powerpoint 2007?
I see how to add a date to the footer that updates automatically, either via "Insert->Header&Footer" or "Insert->Date&Time". Works great!
However, I can't figure out how to do this with a ...
