Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [date-time]

The tag has no usage guidance.

0
votes
3answers
81 views

Excel =TIME() with values over 24 hours displays incorrectly

I'm trying to display times over 24 hours in Excel by using =TIME() but when the values get over 24 hours they display incorrectly. For example I have =TIME(27;42,81;49) which should be displaying 24:...
0
votes
1answer
38 views

Excel Formula : Find out time spent in specific time ranges

Trying to work out a slightly more complex overtime worksheet here: Employee gets paid: 1x hourly rate during weekdays (Mon-Fri) during 08:30 to 17:30 1.5x hourly rate during weekdays (Mon-Fri) ...
1
vote
1answer
72 views

Computer date/time lagging behind

A work colleague's computer is having an unusual problem. Whenever the computer is restarted the time and gets set to approximately 1.5 days previous. The timezone is set correctly, but the computer ...
0
votes
0answers
8 views

map date ranges avoiding overlapped ones (with formula)

I'ts my first post here.. I have a set of dates ranges, and I need to map each range to a number (or label or category) and avoid overlapped ranges in the same label. So the numbers (or labels) ...
0
votes
2answers
44 views

Subtract DateTime in this format

C2 = Start date = 9/16/2018 12:41:02 B2 = End date = 9/18/2018 15:37:12 Using 24 hour format Tried using =TIMEVALUE(RIGHT(C2,8))-TIMEVALUE(RIGHT(B2,8)), it wouldn't work when the result supposed to ...
0
votes
0answers
13 views

System clock resetting, making conflicts with write stamps

My system clock is resetting to a date back in 2016 for some reason and as a work around I reset the date manually every time I boot it. Whenever I boot into Arch with a auto-resetted system date(i.e ...
1
vote
1answer
123 views

Converting “mm/dd/yyyy hh:mm:ss AM/PM” to Seconds Since Midnight

When a cell only has the time, it is a trivial multiplication by 86400 to get seconds since midnight. I don't know how to communicate to excel that I don't need any information about the date.
0
votes
0answers
243 views

Windows was synchronizing with time.windows.com. The following error occurred: The specified service has been marked for deletion. (0x80070430)

Windows was synchronizing with time.windows.com, or any other time source. while updating it I got the following error: An error occurred while windows was synchronizing with time.windows.com This ...
0
votes
1answer
18 views

Excel MOD function/countif logic work around the 12am point

My question is similar to this one in that I'm struggling with Excel's Mod formula. Mostly I just wish for clarification on how Mod function works in relation to time and if I'm making this harder ...
0
votes
0answers
56 views

Make an open and closed date stamp from changing the value of one cell

I'm trying to create date stamps in my Excel file, for a change log. What I would like is to create an open date stamp and a closed date stamp from changing one cell using data validation, i.e. OPEN,...
0
votes
1answer
182 views

How do you change the time of the Linux hardware (hwclock) clock to 24-hour format?

Currently, my hardware clock returns the date/time (hwclock --show) like this: Sat 28 Jul 2018 08:47:47 PM BST .659124 seconds And date returns: Sat Jul 28 21:23:13 BST 2018 I'd like to change ...
1
vote
0answers
12 views

Where Windows 7 store date/time shown in Windows Live Mail 'Sent' folder?

Windows 7: where Windows store date/time shown in list of sent emails in Windows Live Mail 'Sent' folder? When highlight Sent folder, right side show list of sent emails, 3rd column is 'Sent' column, ...
0
votes
4answers
479 views

Excel - extract hours/minutes from time more than 24 hours

The displayed value in A1 is 177:53:00 The custom format is [h]:mm:ss The value when I click A1 is 1900-01-07 9:53:00 AM I need to extract the hours (177) from the cell to another cell Couldn't ...
2
votes
1answer
28 views

DDD, MMMM, YYYY, HH: MM nested script in word 2016 [closed]

I need to "nest" a script to include DDDD, MMMM, YYYY, \ HH:MM to portray like this; Saturday, March 15, 2018, 09:40 AM. I know how to write the date and the time separately but I would like to know ...
0
votes
1answer
54 views

How do I add the year to the menu bar in OSX High Sierra?

So, Tue 19 Jun 2018 13:04:41 ( instead of Tue 19 Jun 13:04:41 ). I want to do this because I take Screen Shots and want to use the Menu Bar Date Time as a reference. So if a series of screen shots ...
0
votes
0answers
120 views

Taskbar Date missing when it is too long

ddd, MMM d y -> Mon, May 28 18 Only happens when there is two M Due to larger width required for M,the taskbar shows empty date Removing the comma will also not worked.My Screen Resolution is ...
0
votes
1answer
38 views

Setup timezone for server

I have a server on Berlin for example, but i have clients in all over the world for an application that provides APIs for Android and iOS. Now I'm confused how should i save the times in the database ...
0
votes
2answers
94 views

using proper date and time stamp in script

In the script I am using I have Sub Saveaspdfandsend() Dim xSht As Worksheet Dim xFileDlg As FileDialog Dim xFolder As String Dim xYesorNo As Integer Dim xOutlookObj As Object Dim xEmailObj As Object ...
0
votes
1answer
49 views

Subtracting two times in libre office base

How can I subtract two times in a query in libre office base? For instance, 10:30 - 9:00 should give 1:30. Thanks. EDIT: As it says in the question, I am having this problem in "base", not with the ...
0
votes
1answer
46 views

Is there a date/time equivalent for Linux Network namespaces?

For the network stack one can create separate network namespaces with iproute2 (see https://baturin.org/docs/iproute2/#Network%20namespace%20management). Is there a date/time equivalent? This should ...
0
votes
1answer
447 views

Windows 10 showing time on lock screen and alarms in 24H, but shows regular 12h on task bar clock?

I recently finally upgraded to Windows 10. Like all my upgrades, I didn't actually upgrade, I used the license to do a clean install. It took me a couple weeks to notice, but I am now noticing that ...
0
votes
1answer
316 views

How to add the date in the taskbar clock without having to resize it?

I don't have much icons so I'd like to keep the taskbar minimal to save more screen space. However I'd like to have the date visible. How can I do that in Windows 7? For example, 15:31 should be 15:...
0
votes
1answer
2k views

How to sync windows 10 clock to internet from commandline?

I would like to be able to synchronize my windows 10 computer clock when it goes out of sync... From the commandline with 1 command. This solution shows how to do it via settings. https://superuser....
0
votes
1answer
75 views

System Clock lags behind by a few minutes over a few days despite chaging BIOS battery

I have a Windows 7 desktop PC with Gigabyte 880GM motherboard purchased sometime in 2013. Off lately I noticed that the system clock somewhat lags behind the actual time by about 5 - 10 minutes over a ...
0
votes
2answers
816 views

How to get time difference from cells formatted as dd/mm/yyyy hh:mm in Excel?

I have two columns of dates and times, formatted as Custom dd/mm/yyyy hh:mm. A third column is =C3-B3, =D3-D3, =x3-x3, etc. As you can see, it does not tell the difference in days, hours and minutes,...
0
votes
0answers
34 views

Security policies setting keeps being changed

I edited the following security policy setting through secpol.msc: Local Policies -> User Rights Assigment -> Change the System Time and removed all users from it, so that nothing, not even LOCAL ...
0
votes
2answers
74 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 ...
2
votes
1answer
2k views

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

Old question are about 32 bit. And they are working on 32 bit. But in 64bit notepad++ there are much less working addons, so the most fastest solution: open simple notepad, press F5 and copy date-...
0
votes
1answer
80 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 ...
0
votes
1answer
2k 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
0
votes
0answers
26 views

Windows 10 date and time settings files location?

I would like to customize my date/time settings on Windows 10 to my native language, which is currently not supported by Windows 10 (i.e. it is not an option in the language settings menu). I assume ...
0
votes
4answers
201 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 ...
2
votes
1answer
906 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 ...
0
votes
2answers
222 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 ...
1
vote
1answer
196 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 ...
0
votes
2answers
60 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 ...
1
vote
1answer
51 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/...
0
votes
1answer
57 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. ...
0
votes
3answers
838 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 ...
0
votes
1answer
206 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 ...
0
votes
0answers
46 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 ...
0
votes
2answers
2k 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:...
1
vote
1answer
629 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 ...
0
votes
1answer
241 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 ...
0
votes
0answers
61 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 ...
0
votes
2answers
98 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. ...
1
vote
0answers
479 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" ...
3
votes
1answer
3k 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 ...
0
votes
2answers
53 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?
1
vote
1answer
199 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 ...