google sheets – Determining type of hours worked past certain time of day

Link to sheet:

Our business pays a different rate for drive time vs. site time. We also pay overtime (over 8 hours), and double overtime (over 12 hours). Sometimes we also have a crew going to several different job sites in a day (no more than 7). Therefore I can have several different pay categories:

  • Drive
  • Site
  • Drive (Overtime)
  • Site (Overtime)
  • Drive (Double Overtime)
  • Site (Double Overtime)

Using IF and AND in combination I can determine Site (DOT) and Drive (DOT). My issue is properly determining Drive (OT) and Site (OT). I have somewhat of a solution in mind using IFS and AND in combination but it seems cumbersome and clunky. Any advice is greatly appreciated.

I have formulas in cells on the sheet listing total hours, hours after break, total overtime, etc.

Here is what a selection of the times looks like
enter image description here

Movie Time tonight?

So every afternoon or evening to kill time, I watch a movie either on Youtube Premium or Netflix Canada. Can anyone recommend me your favourites and the best ones to watch and re-watch on these 2 streaming services?

mysql – Find Max() updated time for a group of users

Database is MariaDB 10.3.25

I have 2 columns that are relevant:

UserID and LastUpdate

UserID consists of user@domain
LastUpdate is a date field.

Here is my issue – I have the current query:

select a.UserID, 
substring_index(a.UserID, '@', -1), 
from MyTable a 
group by a.UserID
having max(a.lastupdate) < '2020-03-31' 

This shows all the Users that haven’t updated in just over a year and the domain. However there is the following scenario that I want to account for:

UserID LastUpdate 2020-08-16 2019-05-16 2021-05-05

With the current query, will be captured, and therefore domain will be captured as not in use, but the user is still active – I want to do a Max(a.lastupdate) but have it grouped by substring_index(a.UserID, '@', -1)
but also spit out all the users for that domain.
I’m sure the answer is starring me in the face…

I will optimize wordpress speed improve load time for $60

I will optimize wordpress speed improve load time

About This Gig

Do you want to Optimize WordPress speed and 1 sec load time but unable to Increase WordPress speed? Then You’re In Right Place.

Most of the Experts just do some basic Optimize WordPress speed and they often break your site in the process of Optimization.

What I Will Do:

I will get your website under 1s load time. This is not quite possible due to the bad hosting server, but I will manage to get your websites down to around 3s load speed, even on free hosting services.

✪ Optimize WordPress speed

✪ Page Speed

✪ Fast Load Time
✪ Improve Google Rankings ✪ Improve Conversions/Money
✪ Increase in Sales
✪ Increase Customer’s Trust✪ Decrease In Bounce Rate

What You Will Get:

  1. At least 10x
  2. Reduced load time
  3. improved web server performance
  4. Up to 80% bandwidth savings
  5. Optimized progressive
  6. Improved conversion rates

Last But Not the least Improvements in search engine result page rankings, especially for mobile-friendly websites and sites that use SSL.

So Hit the order Button to Optimize WordPress Speed Conversion Rate and make more sales and Earn More.


php – Run if comment date more (+ 1hour) current time


Server date and time 04.05.2021 9:00

If comment date and time 04.05.2021 9:58 – NOT run

If comment date and time 04.05.2021 10:02 – RUN

$now = current_time( 'mysql' ); 
    $datacomm = strtotime( get_comment_date( 'Y-m-d h:i:s', $comment ));
    $later = strtotime( date( 'Y-m-d H:i:s', strtotime( $now ) + 7200 )); //3600 seconds = 1 hour
    if( $datacomm > $later ) {
    // run this

My code not work 🙁
Sorry for my English

sdl2 – Delta Time FPS with SDL 2 in C++


I have tried achieving a good delta time and fps counter over the last few days, read and watched a lot about it, but still can’t seem to get it to work.

Here is an example:

#include <iostream>
#include <SDL.h>
#include <SDL_image.h>

int main(int argc, char* argv()) {

    if (SDL_Init(SDL_INIT_VIDEO) != 0) {
        printf("error initializing SDL: %sn", SDL_GetError());

    SDL_Window* window = SDL_CreateWindow("Title", SDL_WINDOWPOS_CENTERED, SDL_WINDOWPOS_CENTERED, 1000, 900, SDL_WINDOW_SHOWN);

    if (!window) {
        printf("error creating window: %sn", SDL_GetError());

    Uint32 renderFlags = SDL_RENDERER_ACCELERATED;
    SDL_Renderer* renderer = SDL_CreateRenderer(window, -1, renderFlags);
    if (!renderer) {
        printf("error creating renderer");

    SDL_Surface* surface = IMG_Load("dot.bmp");

    if (!surface) {
        printf("Error creating surface: %sn", SDL_GetError());

    SDL_Texture* texture = SDL_CreateTextureFromSurface(renderer, surface);
    if (!texture) {
        printf("error creating texture: %sn", SDL_GetError());

    SDL_Rect dest;

    dest.x = 0;
    dest.y = 0;

    SDL_QueryTexture(texture, NULL, NULL, &dest.w, &dest.h);

    Uint64 NOW = SDL_GetPerformanceCounter();
    Uint64 LAST = 0;
    double deltaTime = 0;

    while (true) {
        LAST = NOW;
        NOW = SDL_GetPerformanceCounter();
        deltaTime = (double)((NOW - LAST) / (double)SDL_GetPerformanceFrequency());

        dest.x += 50 * deltaTime;
        dest.y += 50 * deltaTime;

        SDL_RenderCopy(renderer, texture, NULL, &dest);


        std::cout << "Delta Time: " << deltaTime << std::endl;
        std::cout << "FPS: " << 60.0 - deltaTime << std::endl;

        SDL_Delay(1000.0f / (60.0 - deltaTime));

    return 0;

I used the suggestion from this post: How to calculate delta time with SDL?

I print out “delta time” and “FPS” to the console and, while the deltaTime is slightly different each time, the FPS is stable 60 (which is the same value that I use in SDL_Delay to calculate delay in ms).
But the test image is clearly moving not smoothly, it stutters and moves at inconsistent speed, and I can’t understand why.

Please help me understand what I am doing wrong. I just can’t understand it even after looking through many examples.


Facebook Ads 101. Complete Facebook Ads & Marketing Course


Artificial Intelligence In Digital Marketing


Marketing Success With The Power of Social Media Stories


Modern Vlogging…


How to reduce the time complexity of the function below

from itertools import permutations
def next_bigger(n):
    nlist = list(str(n))
    perm = permutations(nlist,len(str(n)))
    perm = set(perm)
    listofperm = ()
    nlist = int("".join(nlist))
    for x in perm:
        form = int("".join(x))
        if form < nlist:
    listofperm = sorted(listofperm)

    if (listofperm.index(n) + 1) == len(listofperm):
        indexofn = listofperm.index(n)
        indexofn = listofperm.index(n) + 1 
    return listofperm(indexofn)

I’m trying to get the next bigger number by rearranging the digits of n but my code is very inefficient can you suggest ways to make my code more efficient and faster

inputs would be any integer

What is suggested way to use iHostedService of .NET core or Windows service when process runs for exponential hour time (up till hours)?

I wanted to create a background job in which I want to use the retry mechanism for that I want to use the Polly. My requirement is like this:

  1. the First retry should be done after 2 hours
  2. the Second retry should be done after 4 (2^2) hours
  3. the Third retry should be done after 8 (2^3) hours.

In short, I want to retry after exponential hours timings. To implement this I have 3 ways:

Assume that I want to post orders to Amazone S3. I got a queue of 50 orders, In which some orders (assume 40 orders) are retried the first time, 6 orders are retried 2nd time, 3 orders retried 3rd time and 1 order retried 4 times on the specific period of time. As per my knowledge, it is not possible to run the iHostedService in exponential timings. If any please let me know. Assume that it is possible then orders have many states, like some orders to be retried 1st time, some are 2nd time and so, on. So, in this case, orders which are retried to be the first time should be executed after 2 hours, orders with 2nd retry should be after 4 hours, etc. My question is in case we find a way to do it how can we accomplish that goal?. Assume that I am going to run the iHostedService service after x number of hours using CRON job.

In this approach, everything is the same as the per above approach, but instead of creating iHostedService, I will create a separate windows service. Here, after some time, things that I have to check that the windows service is running in the background.

With the help of this. And thinking of setup the retry timeout in the hours. But I am afraid with the internal mechanism of the same. Like if I set it like that, will it cause any performance issues on the production server? I am assuming that to achieve the goal, its thread/process continuously running on the server and utilizes the server resources.

I need your help to define the approach which is best for me? which is provide the best performance by utilizing lesser server resources. Above is my research, you can suggest any other brand new ways too. Which can be helpful for me.

Time zone to posts before a date

I want to apply a location-based time zone to posts before a certain date. These posts have been converted from a non-Wordpress database and the datetimes are now displayed with a time offset. Can you help me with that? Thanks in advance for the answers!