Questions tagged [date-time]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
36 views

how to sum up mm:ss in excel column into 1 cell?

I have this time periods and want to see the total duration of all cells. I used sum(d3:d100) , but it does not work. I did format entire column of periods as time.
0
votes
2answers
39 views

How to *format* time duration as hh:mm:ss in LibreOffice/Excel?

I would like to copy the time duration (in seconds) to a cell, then have it displayed as (hh:)mm:ss or similar. For example: Input: 0.49 Display: 0.49 or 0.49s or 490ms (any will do) Input: 857.26 ...
0
votes
0answers
20 views

How can I get the current time of my host PC from Linux virtual machine?

I have a Kali-Linux virtual machine installed on my windows 10 PC (using oracle VM VirtualBox) According to my timezone, the time is 11:26 I came across this problem: When I used datetime.datetime....
0
votes
2answers
29 views

=DATE() won't increment DAY when I try to drag or fill the other cells

I'm working on an excel file to track attendance. The excel sheet should have the flexibility of dynamically changing the year of dates. The user can enter the current year in a cell and it should ...
0
votes
0answers
23 views

Numbers: How to add or subtract hours for a column with date-time value?

Please note that this questions is about Numbers and not Excel. Givens: column x has values of format yyyy/mm/dd hh:mm column y has empty values Desired solution: column y to have values from column ...
0
votes
1answer
52 views

FileZilla: How to get updated German time?

I am using FileZilla for FTP and SFTP data server in Germany with FileZilla language English. When ever I am sending data or taking data from a server, I am getting time (last modified) which is ...
0
votes
0answers
13 views

How to remove unknown "language preferences" in language bar? [duplicate]

I have english a only language installed, I have two keyboard mappings: qwerty us and qwerty international. [ However I modified the date/time format and new "language preferences" did ...
0
votes
1answer
34 views

How can I modify the programmable interval timer value stored in the computer so that the system clock runs faster?

According to this Wikipedia page (https://en.wikipedia.org/wiki/System_time#Implementation) computers use a programmable interval timer (PIT) that periodically interrupts (when reaching a certain ...
0
votes
0answers
42 views

Automatic time sync is not working in Windows 10

I have enabled automatic time sync. But time sync is failing in Windows. Fillowing is the screenshot of the error.
0
votes
2answers
30 views

Calculate remaining time from end time that lies on next date

Shift begins in evening and ends at 05:00 in the morning I am looking to calculate in real time, how much time is left till end of shift. I have been using =NOW() in hh:mm format to calculate and end ...
0
votes
0answers
16 views

Why would a file or folder have no creation or modification dates?

This is something I've tried Google-ing, but aren't sure of. I've got an app on my Mac, A Better Finder Attributes 6, which is for changing date and time of files and folders. In it, there's an option ...
1
vote
1answer
31 views

Windows time off by 1 hour when placing orders, making appointments, etc. on ecommerce sites

In three instances, appointments made with local businesses have been off by 1 hour. Two of those instances were scheduled pick-up times at a local pizza restaurant. Twice, we showed up 1 hour before ...
8
votes
3answers
1k views

Directly open the "Set the time and date" dialog in Windows

For testing purposes, occasionally, I need to change the date and time of the OS. I would really like to have a direct access to the window which allows me to do just that. (In windows 10, you have ...
0
votes
1answer
32 views

Can't sync time on Windows 10

I can't sync time and the Windows Time Service isn't showing on services.msc Already tried: Tweaking repair software. Register the W32Time file but the Windows Time service doesn't show up yet. w32tm /...
0
votes
2answers
52 views

Chart based on dates

I created a dashboard for my work program tracking. I am trying to create a chart based on the dates so I can easily see how many people have done their competency. I have conditional formatting for ...
1
vote
1answer
270 views

Windows 10 - Internet Time Sync Error - Time Out

I have Airtel (ISP) Broadband at home. Same ISP is also my Mobile Network provider. I have DIR 615 router connected to Airtel Broadband, Windows 10 desktop and laptop. When I am on Airtel Broadband ...
0
votes
2answers
73 views

sorting dates and time (in text form) in Excel

My date and time entries in my excel file are written in the form of: Feb 18 at 3:50pm. All of this is in one cell. I was wondering if there is a way to sort this out (arrange chronologically)
1
vote
2answers
58 views

Excel won't recognize timestamp in format of "m/d/yyyy h:mm:ss AM/PM"

I have a column of timestamps (strings) formatted like so: This can be deduced to the following format: m/d/yyyy h:mm:ss AM/PM I'm trying to get them to be formatted into dates but Excel refuses for ...
0
votes
0answers
37 views

How To Add Seconds To Date/Time Format of Prime95 Logging?

Prime95's default log format is MMM dd hh:mm e.g. Feb 26 07:16. I am using Thread Switcher for stability testing which works well switching every 5 seconds. I've had to increase this to 120 seconds in ...
1
vote
0answers
17 views

Debian: Set persistent custom time

I try to set a custom time on my (fresh installed) Debian system. For example, I want to set my time to 2013-05-05. So I disabled NTP on my system with timedatectl set-ntp false, verify that ...
0
votes
0answers
33 views

Excel automatically assumes a date+time format and when choosing text format it generates an unrelated number

How can I format a cell in Excel to show time and date, with milliseconds, I have tried using : (jjjj-mm-dd hh:mm:ss.000) Here's the raw CSV: 2021-02-11 17:32:43.177 2021-02-11 17:32:43.912 2021-02-...
0
votes
0answers
56 views

Why does Windows 10 show the wrong time on the system clock after a reboot?

I'm running Windows 10 on my PC. I have Windows 10 configured to sync to a remote clock. However, every time I reboot my PC, the clock jumps ahead about 45 minutes and continues to display the wrong ...
0
votes
1answer
38 views

Is there any way to reverse the time to the time before the webpage close the fill out form? If the webpage track the local timezone

Is there any way to reverse the time to the time before the webpage close the fill out form? If the webpage track the local timezone.
0
votes
2answers
59 views

Can I display Windows toolbar date in ISO 8601 format?

I want the date in my Windows toolbar to display in ISO 8601 format. Is this possible? If so, how? For example, the date currently appears in the toolbar like this: 1:43 PM 2/3/2021 I want it to ...
0
votes
0answers
13 views

Excel aggregate into timetable

I need to aggregate data from a flat table into a timetable. The table contains: date time start time end resources 2021-01-29 12:15 13:15 200 2021-01-29 12:45 13:45 200 How could I aggregate the ...
0
votes
0answers
20 views

Setting the file modified time to show seconds in Explorer [duplicate]

Does anyone know how to set Windows Explorer Details View to allow the file modified time to show the number of seconds? This used to work in old Win XP. Since the wizards at MS seemed to have removed ...
0
votes
1answer
31 views

Display (or get at least) certain cell last modification date in Excel 2003 file (file extension is *.xls)

I have some Excel table which I filled with values since 2004. To sad I didn't include each row add date in extra cell. Now I want to know that... Maybe it still possible? Maybe *.xls file store that ...
3
votes
0answers
51 views

.bat file: execute command if file modified after main command was started

I have a .bat file executing several commands: Compiling a document with pdflatex and externalizing the tikzpicture creation into .pdf files if some modifications were made since last compilation ...
0
votes
1answer
24 views

Is thеrе any wаy tо propеrly displаy nеgativе timе spаns in Exсеl?

Is there any way to make Excel show a negative time span? If I subtract two time values (say, when subtracting the actual amount of time spent on something from the amount of time planned for it) and ...
0
votes
3answers
128 views

Getting the wrong result subtracting a Date&Time from another Date&Time in Excel

I am trying to subtract a date/time in cell Format Custom: mm/dd/yyyy hh:mm:ss AM/PM. from another time in the same format. I have tried ideas from so many websites as to how to do it but none show an ...
0
votes
0answers
26 views

Windows 10: How to correctly setup time sync with remote time server?

I have one of those old laptops who's hardware/BIOS clock doesn't work, it resets to 2010-01-01 upon each reboot. But I still want to use this laptop because everything else works perfectly fine apart ...
0
votes
0answers
14 views

Date modified is not being shown for any kind of extension files

Time stamp is missing and date modified is not being shown for any kind ox extension files. Iam on Windows 7 professional. Date modified is not being shown for any kind of extension files.
0
votes
0answers
74 views

How to convert dated time to fraction hour format

I have the following format of time data imported from a software (in the lefft section). I need them in hours (fraction) for representation (like the example in the right side). How am I supposed to ...
0
votes
0answers
22 views

Windows 10 - Time Sync Issue After Sign Out

I am running into a weird issue on Windows 10 1909 for a computer on a Domain environment over VPN when signing out of windows. When we use the computer's "Sign Out" feature and leave it ...
0
votes
0answers
18 views

Stamp numbers in different cells in Excel

I have a column with different ID number in each cell. I need to stamp each of this number with the same date (20160608) and a separation _ (underline) between ID number and that date (for example, ...
0
votes
0answers
35 views

Calculating full time difference taking time zone into account and including the fractional parts of a second?

Let's assume you have full times (with dates, time zone, and fractional parts of a second) coming from ls -la --full-time listings: screenshot How do you calculate the durations in seconds including ...
2
votes
2answers
32 views

Bash: Date/Time math problems

The following script takes two inputs, sourceFile="${1}" and trimFile="${2}". The $sourceFile is a video file that is to be trimmed into multiple new files based on data in the $...
0
votes
0answers
8 views

Debian Buster on Pine64: Log rotation kills systemd-udevd and offsets datetime?

Running a Pine64 with HomeAssistant and Domoticz for home automation and monitoring. At night, when log-rotation is called, some strange things happen: Sep 26 00:00:26 localhost systemd[1]: Starting ...
0
votes
1answer
66 views

Calendar in date and time is always in lock state in Mac , how to unlock for always and used it like windows calender

Calendar in date and time is always in lock state in Mac , how to unlock and used it like windows calendar Currently I need to unlock it each time to access calendar the main intention here is to ...
0
votes
1answer
68 views

Date Calculation

I have a Date range, 2020-11-25 as Start Date 2020-12-10 as End date I wanted to get the count of December month days in the above Date range if I am looking for December month.(I need the output as ...
1
vote
1answer
395 views

How to extract date from filename on Windows [closed]

I need to do hand formatting date values for some files. I have just extracted 6000 photos/videos from an application and they are all named following this structure, with different dates and times ...
0
votes
1answer
101 views

Different serial numbers behind the same time value in Excel

I have a number of 10-minute interval time series CSV files. Sometimes there are single rows missing in the files. To complete the missing rows, I decided to search for them in Excel and insert new ...
0
votes
2answers
2k views

MS Regedit Hex to Date Conversion

I'm trying to analyze my redundant network profiles on Win 10 via registry path: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\NetworkList\Profiles However, I'm unable to interpret ...
0
votes
0answers
19 views

Why I can't change the time format of a Standard user account

In simple words we have Desktop computer with windows 7. I'm Administrator user and my wife and my daughter are standard users. So while explaining to my daughter I just looked for time in ...
1
vote
4answers
104 views

Rationale behind Date created, Date modified` & `Date` on Windows 10

I am trying to understand the rationale behind Date created, Date modified & Date on Windows 10 File Explorer. Yesterday, 30th June 2020 I downloaded a Youtube video and its subtitles in these two ...
1
vote
1answer
723 views

Excel: total of time difference formatted in months, days, hours, minutes and seconds

I need an Excel Ninja. I want to format a cell in Excel so the total time difference is formatted in months, days, hours, minutes, and seconds. Right now, I don't know how to add "months" ...
-1
votes
2answers
40 views

How To Sort Time Data, to only showing exact clock (hh/mm/ss)? [closed]

i want to sort my time data (there's a lot of it), to only showing data that only show the exact clock in hh/mm/ss format, so i can delete the unnecessary data. for example, from : to only showing ...
-2
votes
1answer
52 views

in code better time format strategy. milliseconds or concat time string? [closed]

Which of these should I choose for time formatting? 1. Wednesday, June 3, 2020 11:34:10 PM GMT-04:00 2. 1591241594000 what answer should have I provided? I was guessing 2. but is there a ...
1
vote
2answers
49 views

How do the major OS like Windows, Mac and Ubuntu/Redhat handle DST and time that goes back 1+ hour?

When time is out of sync, I understand most of the modern operating systems have NTP software that do it in smart increments spreading it through a large interval such that it doesn't affect most ...
0
votes
1answer
47 views

How should this datetime format be interpreted? "20190328012019.000000+120"

20190328012019.000000+120 That's the weird timestamp outputted by WMIC commands on Windows. I assume that 2019 is the year, 03 is the month and 28 is the day, and that 01 is the hour, 20 the minute ...

1
2 3 4 5
10