All Questions
5,028
questions
0
votes
0
answers
27
views
Convert string to timestamp in pinescript
I'm importing a string that I then turn into an array. I would like to use the date and time values inside the array to draw lines from. The issue seems to be that a const string is expected. Is there ...
1
vote
2
answers
48
views
data frame breakdown by year, rounding up by duration of each period
I have a data frame of county executives and the first and last years they served.
I am running a panel study with county-year as the unit of analysis. The date range is 2000 to 2009.
I will like to ...
- 383
-1
votes
0
answers
38
views
VBA Excel prevent file from opening after trial has expired
Hello there i am seeking some assistance with my code. I got most of it incorporated. I am trying to create a code when the file is open for the first time on someone's computer that the file ...
- 5
0
votes
1
answer
45
views
How can I modify this script to select any folders dated in the last 12 months?
I have a folder directory (shown below) that contains folders titled "year-month." They will be continuously added over time. I am trying to write a python code that selects any files in ...
1
vote
1
answer
77
views
Google sheets - Calculating shift hours
The goal of this spreadsheet is to calculate total hours worked and out of that figure out how many hours has been in the day shift (from 6:00 to 22:00) and how many hours has been in the night shift ...
-2
votes
1
answer
94
views
Subtract minutes from Date by using Calendar fails
I'm writing an app that must find some time for alarm (from Date object), and then should subtract several hours and minutes (by using Calendar object) selected by the user (interval, several hours ...
-1
votes
1
answer
16
views
Display issues in cells when splitting date/time into multiple columns
When using the =right formula to split the date and time so that just the time displays in a separate column, the values didn't always display correctly. First the values came into the new column as ...
0
votes
0
answers
12
views
Android date and time stuck on auto
Android os. It is stuck on auto date and time. When set to off, on reboot, it goes back to on. For auto date and time. I want it on manual.
Is there someone who can go Into the code , or fix it in ...
0
votes
3
answers
62
views
Sort %b-%y in x-axis in ggplot2
The x-axis supposed arrange the date in ascending order, such as "Nov-23", "Feb-24", then "Apr-24". How can I handle this situation in R? I have tried to use as.POSIXct() ...
- 213
-1
votes
1
answer
140
views
How to calculate worked hours - Day, Evening and Night shift - with midnight crossing [duplicate]
I have a schedule template with a shift start time and end time, and I'm trying to calculate hours worked in the Day (6am-4:00pm), Evening (4pm-8pm) and Night (8pm-5:30am). I'm convinced that there ...
- 67
1
vote
2
answers
61
views
Gnuplot, use time related X-axis variable and show day label (when it changes ideally)
I have cvs data out from sqlite3, a small edited sample:
conTime
dayXS_date
Ref-AHx
Ref-Cx10
Bed1-AH
Bed2-AH
Bed1-Cx10
Bed2-Cx10
6466
2024/05/14
510
149
583
604
210
222
6467
2024/05/14
510
147
587
...
- 15
0
votes
0
answers
32
views
How can I delete time from date in moment().calendar()?
I am trying to get Today and Tomorrow titles from date using Moment Calendar.
In case moment(date).calendar() I get Tomorrow at 12:00 AM. But I need without time. Just Tomorrow
In case moment(date)....
- 53
0
votes
1
answer
104
views
convert UTC timezone into custom local time with daylight savings offset (and back) in google sheets
I'm looking for a way to convert standard UTC timestamps into a valid Date Time values of local timezone with daylight saving oscillation in mind.
...using this unnamed calendar app, that does not ...
- 1
0
votes
1
answer
51
views
How to create a custom date and time input in vue3 composition
I'm creating a reservation form in vue3 composition API, I've been able to set the date input to start from the current day, so any other day before the current day is invalid and cannot be selected. ...
- 59
1
vote
2
answers
67
views
Finding Next Available Datetime Combining Weekly Schedule and Special Days in PHP
I'm working on a PHP project where I need to calculate the opening times for a business, which includes both regular weekly schedules and special non-standard times for holidays. I have two arrays: ...
- 580