Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
312 views

How to change a Generally formatted "20170824 08:45:58:544" into a Time formatted hh:mm:ss.ss?

The title is the gist of my problem. I've got a couple of thousand of these I need to convert into a hh:mm:ss.ss format while retaining (though not showing) the yyyymmdd converted to a mm/dd/yyyy ...
John's user avatar
  • 1
5 votes
5 answers
10k views

How to insert date/time in notepad++ 64bit

Old question are about 32-bit. And they are working on 32-bit. But in 64-bit notepad++ there are much less working add-ons, so the fastest solution: open simple notepad, press F5 and copy date-time ...
XuMuK's user avatar
  • 300
0 votes
1 answer
190 views

Why does my dual boot machine have diferent times in different times in each OS

I currently have have a dual boot setup with Linux Mint Mate 18.2 and Windows 7. What is strange is that during installation I gave both systems the same locale settings (or at least that is what I ...
natral's user avatar
  • 393
0 votes
1 answer
11k views

Custom Date Format in Microsoft Word 2016

I would like to be able to insert a date format in Microsoft Word that is not included in the list of existing formats. Specifically, I want this format: DD th day of Month, YYYY
Danny Arenales's user avatar
0 votes
4 answers
629 views

Excel 2016: Work sheet, subtraction of time [closed]

I am working on a work sheet. Sometimes I work late and sometimes long hours (outside the 24 hour time frame). I am looking for a automated solution in Excel where I can easily calculate the total ...
Alexander's user avatar
3 votes
2 answers
2k views

Time does not update automatically on Windows 10

I have a really big problem with the time on windows 10. Every time I start computer, I have to manually set the correct time. I don't know what the problem is. In settings "Set time automatically" is ...
irakliy01's user avatar
  • 133
1 vote
2 answers
2k views

How to extract EXIF creation date and set file creation date

The transfer of images from IPhone somehow screwed up the file dates. I want to set them from EXIF data. I already found a solution but wasn't able to convert this into a batch job. Feel free to ...
JPT's user avatar
  • 200
1 vote
1 answer
968 views

RunAsDate: Change DateTime for spawned process

Using RunAsDate, it's possible to change a DateTime for a single process. However, when this process spawns another process, for example by interacting with a DLL or another .exe, the other process of ...
tmighty's user avatar
  • 147
1 vote
2 answers
2k views

Want to sort my list of files according to date using Unix

My list of files is like ... Oct 13 03:50 TEST_j002_26047.trc Oct 11 17:10 TEST_j001_26047.trc Oct 10 10:43 TEST_j000_6096.trc Oct 12 02:52 TEST_j001_26048.trc I want my output in a sorted way ...
Vivek varshney's user avatar
1 vote
1 answer
222 views

Reverse cell formatting, how to explain a certain datetime format to Excel

I am aware that Excel can modify the appearance of a cell content, using "Format cells". When I enter "20000" in a cell, and I use "Format cells", more exactly "Date", Type "14/03/2012", I see "03/10/...
Dominique's user avatar
  • 2,183
0 votes
1 answer
153 views

Format an arbitrary date in Word

I need to insert a specific date in Word and have it formatted with the name of the day in the form "Name of the Day, DD.MM.YYYY". If I change the date the name of the day would be change accordingly. ...
almerillat's user avatar
1 vote
4 answers
19k views

Convert number of minutes to time in Excel hh:mm format

I have a set of data that is represented in minutes. This data needs to be converted to hours and the remainder to minutes. For example, in column A I have 120 and in Column B I need to present the ...
Ana's user avatar
  • 21
0 votes
1 answer
2k views

Create a keyboard shortcut to trigger time sync

I have a pretty old laptop and recently it's stopped keeping time unassisted (I know the cause but am too cheap to fix it when I'm already saving for a new laptop). I've created a scheduled task to ...
Alex's user avatar
  • 143
0 votes
0 answers
105 views

Getting Current Date and time without using Internet Services or RTC

I have a MT7681 module with limited interfaces. One of the interface is Wi-Fi. I have been using Wi-Fi interface(NTP) to get current Date and time. So, in one of the use case Internet services are not ...
apurvPadole's user avatar
1 vote
2 answers
22k views

How to compare time between 2 columns in Excel

I have 2 columns of date in my Excel spreadsheet, and I want to calculate the time (in sec) between the 2 dates. Time Time1 2017-08-22 19:45:22.2327928 2017-08-22 19:45:...
n179911's user avatar
  • 3,673
1 vote
1 answer
2k views

How do I set the date and time sync on fedora lxde?

From the following link (https://spins.fedoraproject.org/) I installed the LXDE spin for Fedora 26. For the life of me, I cannot seem to set the time to sync with a time server so that is it correct ...
gideon's user avatar
  • 67
0 votes
1 answer
642 views

how to allow only specific format with data validation (hh:mm - hh:mm - shift scheduling)

so basically I need a formula which allows only data in the following format: hh:mm - hh:mm (this is for shift scheduling, so e.g. 08:00 - 16:00) Space before and after dash (-) is absolutely a ...
Kacper Tobolski's user avatar
0 votes
0 answers
265 views

Format Excel datetimes with fixed widths and typical software formats

How can Excel be used to format dates with fixed widths using formats typical to software applications (MySQL DATETIME format, ISO 8601, RFC3339)? While it would be "nice" to convert to UTC, I am ...
user1032531's user avatar
  • 1,651
0 votes
2 answers
609 views

Advanced date sorting in excel

I'm currently working on a project that requires looking at temperatures measured once every hour. As with all instruments there have been hours/days where the instruments haven't been measuring. ...
Kristian Petersen's user avatar
1 vote
1 answer
2k views

Windows 10 Normal and Small Taskbar mode whilst keeping "Day of the Week & Date" shown at all times

In Windows 10, in "large icons" taskbar mode (32x32 taskbar program icons), I see the date plus first two letters of the week (Dutch) showing nicely: But, when I activate "use small taskbar buttons" ...
Sam's user avatar
  • 312
16 votes
3 answers
34k views

Disabling time synchronization with Hyper-V

I found that when attempting to change the Date/Time settings on a Hyper-V virtualised Windows 8 OS, I found that the date would immediately change back to the correct date. How can I prevent the ...
Ciaran Gallagher's user avatar
0 votes
2 answers
3k views

Modify the time and date from the command prompt

I'm working with the command prompt and I want to change the time from the command prompt. Is there a way to change it?
Luca Serafin's user avatar
1 vote
1 answer
284 views

Why can't I get to the "Update time from internet" dialog more easily?

Here's what I do: I rightclick the date/time applet in the taskbar and select "Adjust date/time". Then I want to click the "Change" button under "Change date and time", but it's disabled. Any idea ...
Stefan Monov's user avatar
  • 1,641
1 vote
1 answer
81 views

How can you extract the number of hours until a date?

I have dates in a spreadsheet formatted in this format: 5/10/2017 2:00:00 PM There is a whole column of dates like that. Formatting shouldn't matter, but I want it in that format as this is a shared ...
InterLinked's user avatar
  • 2,496
1 vote
1 answer
1k views

How to add missing options (control panel in start menu & date format) in Windows 10 Creators update? [closed]

I recently updated to the Windows 10 creators update and noticed that the option to access the control panel was removed from the start menu and an option for the date time format as well. Is there ...
FewL's user avatar
  • 367
1 vote
1 answer
1k views

Date and Time format not changed at Windows 10 Lock Screen

I changed Date and Time format from Region Settings in Windows 10 and it's changed everywhere in the system, but not changed on the lock screen. While changing, Windows 10 was logged in with an ...
FewL's user avatar
  • 367
4 votes
2 answers
3k views

Removing 12-hour time from Windows 10 login screen at startup (24-hour already set) [duplicate]

So my problem is somewhat minute, and the main problem was addressed here, but when I first turn my computer on, it always shows the 12h format. The account I log into is the admin account, and once I ...
Asinine's user avatar
  • 67
0 votes
1 answer
61 views

EXCEL 2016 - compare day-number

I have a Excel column with date in the format: d. This shows just the day-number of the month e.g. 2017-05-21 is shown as 21. If this number is smaller than the one in the column above, I would like ...
Morten Repsdorph Husfeldt's user avatar
0 votes
1 answer
412 views

Exported duration times come up at time of day value in excel, any solutions?

I have the problem with a sheet I downloaded. Right now, online on its platform it displays the number correctly 0:31 (duration of a call) but when I export the list to excel for tracking, it comes up ...
Chris's user avatar
  • 1
0 votes
0 answers
49 views

Windows time update doesn't work properly [duplicate]

In those days you don't want to set your system time manually. But even though my system is configured to do auto time updates the time is sometimes very inaccurate (more than a minute off). When I ...
principal-ideal-domain's user avatar
0 votes
0 answers
742 views

Missing event logs due to System Time Change

On 8th April 8:30 PM my PC (Sony VAIO Laptop, Windows 10, 64x) faced some problem and it turned itself off. The screen suddenly just hung and within few seconds it turned off (without proper shutdown ...
Vijay Chavda's user avatar
0 votes
0 answers
1k views

Convert datetime string to date/time: OpenOffice

Format of text string: "05/04/2017 04:35 PM CEST" Desired value: 5/04/2017 10:35 AM Or "07/15/2017 01:05 AM CEST" to 07/14/2017 7:35 PM Possible? OO 4.1.3 on Win7 Home Premium SP1
Bob Jersey's user avatar
1 vote
0 answers
271 views

Windows 10 Time/Date updating without network connection?

Context: Windows 10 Pro I back-dated my Win 10 Pro machine (rewinded a couple months, had to turn off 'Set time automatically' option), and wanted to make sure that no software was checking the date/...
Aaron Marcus's user avatar
-1 votes
3 answers
416 views

Why do date ranges in computing start at ancient periods?

Reading the Wikipedia article for HFS+, I noticed the allowable date range is January 1, 1904 – February 6, 2040. Likewise, the range for NTFS is 1 January 1601 – 28 May 60056. In my mind, this is ...
svbnet's user avatar
  • 107
1 vote
0 answers
47 views

Delete time data labels with zero value from a bar chart?

I am looking to remove data labels with a time format h:mm with a value of zero automatically from my pivot bar chart. Is there any way I could do this? Here the example Pivot bar chart displaying 0:...
Max Beggel's user avatar
0 votes
2 answers
121 views

Converting a weekly schedule into a table of dates

I'm tracking fruit consumption. In this example, I eat 5 fruits subdivided into 10 types (2 each) on certain days of the week at certain times of the day. Sometimes, I don't eat a certain type of ...
BCLC's user avatar
  • 71
13 votes
7 answers
17k views

Windows 10 always showing wrong time (when dual-booting with Ubuntu)

This is driving me crazy. For some reason Windows 10 is showing me the UTC +00:00 London time instead of UTC +01:00 Vienna although I set it accordingly: If I disable "Set time automatically" and re-...
Stefan Falk's user avatar
1 vote
1 answer
8k views

move file to folder based on creation date

I have files that constantly get pulled down from an ftp site into a directory. They are all named in this format: yyyyMMdd_file1.txt 20160612_file1.txt 20161225_file2.txt I am trying to move files ...
Narzard's user avatar
  • 3,687
21 votes
6 answers
10k views

Use ISO time and date format in KDE 5

I've been using Dolphin for organising pictures. I would like to see the modification time and date displayed in ISO format. It is easier to read for me. I used to be able to configure that in KDE 4: ...
dhill's user avatar
  • 475
3 votes
2 answers
615 views

How to display the current "Day of the Week" next to the 24H time in Windows 10?

I would like to see a short two letter day of the week abbreviation like MO for Monday SA for Saturday before the 24H time dusplay on windows 10. As you can there's plenty of room there. For most ...
Sam's user avatar
  • 312
1 vote
0 answers
1k views

How to correct column with dates in MDY and text to DMY?

I have a column of dates extracted from a database, but the system exports the dates in MDY format. My computer works in DMY so it converts December the 2nd to February the 12ve, and November the 23rd ...
Karl's user avatar
  • 63
0 votes
1 answer
43 views

MS Excel Date/Time Difference

I am trying to determine the time difference using two fields that contain a Date/Time stamp. The Date and Time are separated by a 'T'. I'd like the final answer to be converted into a decimal ...
Charlie's user avatar
4 votes
5 answers
2k views

Computer doesn't keep time even though on and connected to Internet

Recently my Windows 8.1 computer has not been keeping time. At first I thought it was the CMOS battery but since my computer is always on and set to update with the internet it should be able to keep ...
NULL's user avatar
  • 121
3 votes
0 answers
247 views

Use Blat to send mail, why time send is one hour ahead than time received?

Use BlatJ (Japanese version of Blat) to send email, the command is: blatJ test.txt -t [email protected] -s "test from blatj" -f [email protected] I sent the mail at 09:30, and received by ...
aruku7230's user avatar
  • 153
2 votes
1 answer
1k views

Excel date precision and unexpected discard of <1s accuracy

The Problem A datetime cell contains data with accuracy down to tenths of a second or greater precision, but discards this accuracy to "second"-level precision when the cell data is edited, even if ...
AndyBrown's user avatar
0 votes
1 answer
1k views

Parse date/time string in Excel

I have a log file from some system, the date/time format used 8/Sep/2016:08:21:32 -0500. How can I convert it into Excel recognized date/time value?
hardywang's user avatar
  • 239
0 votes
1 answer
190 views

Excel Formula for auto date/time subtraction

I want to do the following in cell K14: If cell D14 contains C17, take cell F14 and subtract 3 hours and 45 minutes. The date/time format I am using is a Julian Date/military time, so 16271/1845 ...
Deaula's user avatar
  • 1
11 votes
1 answer
8k views

Change OS X date and time format in menu bar

Basically I want to change the date/time that appears on the right side of the menu bar in OS X to only display numbers (like Windows). I've managed to add dates but currently it shows: 10 Aug 10:49 ...
Warpzit's user avatar
  • 1,925
15 votes
1 answer
3k views

How to get rid of fractional seconds in find using -printf?

I'm running this shell command to get the most recent 20 PHP files modified on my server. find . -name '*.php' -printf '%TY-%Tm-%Td %TH:%TM:%TS %Tz %p\n' | sort -r | head -20 The output is like this:...
Drakes's user avatar
  • 387
6 votes
2 answers
20k views

Why "Windows Time" service always is set to Manual in Windows 10?

I have a laptop with a battery damage. I plug to energy only once a day. When I turn on always the time is wrong. Searching I found that the problem is "Windows Time" service is set to Manual (...
Gabrielizalo's user avatar

1 2 3
4
5
11