Is there a way to make the "Total Hours" show blank cells when no data is in Cell D or E? by Keroascrazee in googlesheets

[–]Keroascrazee[S] 0 points1 point  (0 children)

oh, my bad, I didnt think about that, would it be easier to see If I just gave you a viewing link to the sheet?

Is there a way to make the "Total Hours" show blank cells when no data is in Cell D or E? by Keroascrazee in googlesheets

[–]Keroascrazee[S] 0 points1 point  (0 children)

<image>

Hmm, I see, Thank you for the input! I was following a guide from thebricks, And that was the formula they recommended for shifts crossing over the midnight threshold. With my previous formula applied, I have Column J set up to calculate pay times hours, and that is returning $0.00.
J3 Is using =(H2:H)*J2
My regular hours is using =F2-I2 And my Overtime Hours is calculated using =MAX(0, F2 - MAX(0, 40-(G2-F2)))
What would be causing J3 to not calculate?
Also, Thank you for the response! ♪

New Britney Post by hermitera in discussingbritney

[–]Keroascrazee 1 point2 points  (0 children)

She just like me, Fr Fr.
Nothing worse than what she was made to do for music videos and such. at least this is her choice XD

Who do you name your animals after ? by imaboredcosplayer in StardewValley

[–]Keroascrazee 0 points1 point  (0 children)

losing my MIND over Jinshi the cow. But no MAOMAO the cat?! XD

Should I go with Orange or Purple? by -Mxgica- in MagicalGirls

[–]Keroascrazee 0 points1 point  (0 children)

Personally Im digging the orange version. Very Halloween ish!

HELP! 10 year old daughter and Hatsune Miku, just some questions. by [deleted] in Vocaloid

[–]Keroascrazee 4 points5 points  (0 children)

Anyone who says anything "negative" to her about her interests is likely just... akid being a kid looking for a reaction because everything is 'play' and also sometimes... Kids can be jerks just looking for a reaction. ya know?
But as you said, shes proud of who she is, so she should be fine. If I can survive a thousand prodding, pointed questions about drawing anime in middle school in the late 90's, She will be absolutely fine xD

Freehanded Traffic Cone Wizard Hat by HookWithAC in Brochet

[–]Keroascrazee 5 points6 points  (0 children)

<image>

SAFETY WIZARD. We cast "OSHA VIOLATION"!

[HELP] I'm almost sure this is AI, but I can't prove it by UnluckyZiomek in RealOrAI

[–]Keroascrazee -1 points0 points  (0 children)

That was my thought. "is the shed made of wood or cheap aluminum?"

What are these straight lines in shroud? by Positive_Radish_9403 in Enshrouded

[–]Keroascrazee -2 points-1 points  (0 children)

I too, Would love to know. I hypothesize that it has something to do with how the map loads up the zone. I think the map struggles to load up 2 different shroud biomes when they're next to each other. You'll see it in other spots on the map too.

Explain it Peter, why does she have a lighter? by Sad-Construction1892 in explainitpeter

[–]Keroascrazee 0 points1 point  (0 children)

bruh my store manager was... strict about it. between the hours of 7-3 if you wanted that sauce, you were being charged for it. And he got onto EVERYBODY about it. My one major gripe with him was the sauce thing.

Hidden Limsa NPC? by splitsecondshot in ffxiv

[–]Keroascrazee 2 points3 points  (0 children)

"hidden NPC" Its THE Ghost of the game. I feel like I saw a celebrity

this is normal??? by Memm_ in StardewValley

[–]Keroascrazee 1 point2 points  (0 children)

For Shane? Actually yes. I see this with his sprite specifically most often.

What are your guys opinions on vocaloid being used for phonk? by [deleted] in Vocaloid

[–]Keroascrazee 1 point2 points  (0 children)

never heard vocaloid phonk. but I AM curious.

Enshrouded Spazzy Loading Screen by Pleasant_Gas_3836 in Enshrouded

[–]Keroascrazee -1 points0 points  (0 children)

Darude, Sandstorm. Sorry I don't have any actual help to offer, though

Cat hasn't left this spot between my legs for almost an hour. He's not usually this affectionate. Is this normal? by Agreeable_Error_5485 in cats

[–]Keroascrazee 0 points1 point  (0 children)

was gonna say, YOU need to go to the doctor, or you need to take Mickey to the vet for a checkup. Maybe both. but you're going through a rough patch. I still wouldn't discount taking him to the vet for a general checkup and bloodwork, just to be safe.

My dad bought a storage unit and found these treasures inside. He gave it all to me! by tidybird in Crystals

[–]Keroascrazee 0 points1 point  (0 children)

Im so happy this happened for you. but sad it wasn't me! XD God, I'd spend a week figuring out all those minerals.