u/candid-milk4381

Recommendations for Parent YouTube Algorithm Change

Hello everyone! This is my first time posting here and my first time on mobile, so if this isn’t the right sub or if there are formatting errors, I apologize.

Essentially, my father has gotten into a cycle where he watches YouTube shorts and subsequent long form videos all day long. He does not like being asked to do something else. The issue is that he is stuck in a corner of the algorithm that is the fear mongering, World of Absolutes (keywords like annihilated, destroyed, shock). He just surfs, and he made his way from his normal interests in outdoor videos, documentaries, and cooking into a nonstop stream of negativity.

I am hoping to get recommendations of channels to subscribe to that can get his channel back to more of a normal, and any recommendations on how to push away the harmful content. One channel I subscribed to today was Odd Animal Specimens because of how calm and informative it was, but I’m open to anything.

ETA: He also listens to this on the TV in the main room on FULL volume, so please try to limit YouTubers who yell by default

reddit.com
u/candid-milk4381 — 9 hours ago

How do I make the duration calculation stop calculating when there are no values?

I am currently trying to create a google sheet to keep track of my family's service hours & charity donations. Currently, I have run into an issue where my "Hours Total" calculation is inaccurately putting out numbers when there aren't enough values to finish the calculation.

My formula for this column is =ABS(AC9-AF9)*24.

If this formula is not the most efficient, please tell me. I want it to be able to handle any negative hours issues in the future, just in case.

Here is an image showing my issue:

https://preview.redd.it/e5hoo1w9kq5h1.png?width=341&format=png&auto=webp&s=bc072405bd45603a5ab3444a466e3ce1f0cc85e5

Thanks in advance for any tips, I'm not completely new, but I am by no means very good, haha!

reddit.com
u/candid-milk4381 — 29 days ago