sharepoint online – Check if a time is between two other times including minutes

I have a PowerApps form which contains an adjustable “Submission Date” field. Here is a screenshot to show what I mean:
enter image description here

I am trying to come up with a formula for a calculated column in SharePoint called “Submission Status” to determine whether or not the form was submitted during the day, which in my case would be between 9:30 AM to 5:00 PM (inclusive) on a weekday. I can get it to work for 9:00AM to 5:00PM, however I can’t get it to work with a schedule starting at exactly 9:30AM. I’m fairly new to SharePoint so I’m not sure how to account for those minutes.

For reference, this is the formula I’ve got that works for 9:00AM – 5:00PM :

=IF(OR(HOUR((Submission Date))>17,HOUR((Submission Date))<9),"Submitted after hours",
IF(OR(TEXT((Submission Date),"dddd")="Saturday",TEXT((Submission Date),"dddd")="Sunday"),"Submitted on a weekend",
IF(OR(HOUR((Submission Date))<=17,HOUR((Submission Date))>=9),"Submitted during the day")))

Any help would be appreciated

boot – Multiply claimed blocks repeating themselves with no end I can see they are game files what do I do 20.04 I have tried multiple times to fix it reins

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.

mysql – WordPress doesn’t save changes some times

I have an wordpress website and have a lots of user’s that write content in it. Sometimes when users edit or create new post and save it, after refresh it disappeared.

I have a backup system that mysqldump all database every 8. I don’t know that this may cause the problem or not.

mysql – WordPress don’t sage changes some times

I have an wordpress website and have a lots of user’s that write content in it. Sometimes when users edit or create new post and save it, after refresh it disappeared.

I have a backup system that mysqldump all database every 8. I don’t know that this may cause the problem or not.

windows – Mysterious disconnects every 4 hours at specific times (e.g. 08:02, 12:02, 16:02 etc)

we have a real odd issue. Multiple users have noticed that their computers are unable to access various web and file based services at specific times 4 hours apart.

I’ve noticed the “disconnection” at 12.02pm myself and trying to access internal web based systems gives me a 404 page not found error. Others have noticed file shares becoming unavailable.

The outage lasts approximately 2 minutes each time.

We’re running a 2 node Server 2019 hyper-v cluster with an infortrend SSD SAN backend and the services I describe are distributed across both nodes.

I’ve checked the host servers even logs, I checked the network switch logs and even some client event logs and nothing seems to correspond (or be anywhere near) to the time that the outage happens.

In tests we’ve run multiple Pings to hosts and VM’s from endpoints to see if there is a network interruption but there isn’t so much as a fluctuation in the MS response times. I realise Ping is a bit of a sledgehammer but given the duration of the outage I would expect to see something reflected but again nothing.

I’m at a complete loss so would be grateful for literally anything that might point me in the right direction.

thanks in advance,


Ultra-high-density hard drives made with Graphene store ten times more data

Graphene can be used for ultra-high density hard disk drives (HDD), with up to a tenfold jump compared to current technologies, researchers … | Read the rest of

python – 3d Cistercian numbers mini game (MatPlotLib), inputting similar xyz coordinates 50 times, how to streamline?

Dear coding black belts,

My code is working but seems clunky.

  • Take a random number from 1 to 99,999
  • Display it in 3D in a modified version of the Cistercian numerals from 13th century monks (adding one sagittal dimension)
  • Ask for user input and check if the answer is correct.

I breakdown the random number to it’s digits components in a list

Cistercian = randrange(1, 99999)
List_digits = (0, 0, 0) + (int(x) for x in str(Cistercian))
units = List_digits(-1)
tens = List_digits(-2)
hundreds = List_digits(-3)
thousands = List_digits(-4)
man = List_digits(-5)

(“man” means “10,000” in Japanese)

I predefined 14 points in the 3d space.

P1 = (-40, 0, 120)
P2 = (0, 0, 120)
P3 = (40, 0, 120)
P4 = (-40, 0, 80)
P5 = (0, 0, 80)
P6 = (40, 0, 80)
P7 = (-40, 0, 40)
P8 = (0, 0, 40)
P9 = (40, 0, 40)
P10 = (-40, 0, 0)
P11 = (0, 0, 0)
P12 = (40, 0, 0)
P13 = (0, -40, 80)
P14 = (0, -40, 40)

then I map each digit as connections between the points above :

if thousands == 1:
    x_values1k = (P11(0), P10(0))
    y_values1k = (P11(1), P10(1))
    z_values1k = (P11(2), P10(2))
    plt.plot(x_values1k, y_values1k, z_values1k, color='k', lw=3)
elif thousands == 2:
    x_values2k = (P8(0), P7(0))
    y_values2k = (P8(1), P7(1))
    z_values2k = (P8(2), P7(2))
    plt.plot(x_values2k, y_values2k, z_values2k, color='k', lw=3)

so it’s used 50 times. I’d like to define a function that would only require the input of the coordinates once instead of re-writing each steps. I’m struggling with how to manage that. I tried defining a function, but I was struggling with the plt.plot aspect, where x_values, z_values, y_values is different each of the 50 times.

for reference, lines 168 to 506, full code below


example of output
3d Cistercian numbers with Matplotlib

sound ‘puntpuntpunt’ a couple of times per hour on Motorola G8. Punt is Dutch for point or dot

Since the update to Android 11 on my Motorola G8 every now and then the phone says ‘puntpuntpunt’
I noticed the way screenshots are made have changed, instead of using the powerbutton now I need the volume (down) and powerbutton together. I have a feeling it is related to talkback. No solution yet.

Still getting emails after unsubscribing multiple times from LATOKEN

I have unsubscribed a mail but still I’m getting emails from the LATOKEN, What should I do?

What are the legal risks of continuing to email someone who unsubscribes from their email list?

Is LATOKEN legit?

unity – how to keep track of how many times a player has collided

i have a player who collects keys to open a gate. i need to keep how many keys he has collected. i use collision to detect the player has collected the key or not.

private void OnCollisionEnter(Collision collision)
    if ( == "exit board")


    if ( == "ID CARD")
        keycheck = true;