▲ 4 r/excel

Calculating hours and comparing that solution

I'm almost there, but I can't quite finish this one.

I'm trying to track how much usage I get out of my continuous glucose monitor. They're supposed to last 10 (or 15) days with a 12-hour grace period, so 252 or 372 hours.

I have Start_date_and_time (C) and End_Date_and_time (D), and I've got the two time columns formatted as dd-mm-yy h:mm.

I've got the duration column (E) formatted as [h]. The calculation there is =(NUMBERVALUE(D2-C2)). With that formatting, I get the correct value displayed, but when I do the math to compare it to the expected duration, I get the wrong number.

With example data of 6/26/2026 16:31:00 and 7/6/2026 19:31:00, I get 243 displayed, which is the correct number, but I can't do math against that, because the VALUE of E is 10.125. How do I get the actual number of 243 hours to be available for use in another cell?

Edit for version: Version 2606 Build 16.0.20131.20086 64-bit

reddit.com
u/cmhbob — 3 days ago

How do data entry jobs work?

How do you get the stuff you're entering data from? Is it like scanned forms that you're typing into a screen, or is the stuff mailed to you, or what?

reddit.com
u/cmhbob — 13 days ago

Primary Elections 6/16

Please get out and vote Tuesday. Polls are open from 7 AM to 7 PM. If you're in line at 7 PM, you'll get to vote.

Note that several polling locations have changed. You may see a sign at your old location; you may not. Check your registration at https://okvoterportal.okelections.gov/

The biggest thing on the ballot is SQ 832 which will raise the state minimum wage to $12 per hour in 2027, $13.50 in 2028, and $15 in 2029. Beginning in 2030, the wage would be adjusted based on changes in inflation. It also expands who's covered by the minimum wage. The state's minimum wage has not changed since 2009.

In a couple of primaries, there are only two candidates from a single party, so you'll actually be choosing the final candidate. See the election list.

Oklahoma Voter Identification rules

Time off for voting

reddit.com
u/cmhbob — 20 days ago

Google Messages notification sounds

With Samsung Messages, I used to have the ability to select a distinct sound, separate from other notification sounds. I can't see where to do that with Google Messages. Did we lose that?

T-Mobile device running OneUI 7 and Android 15.

reddit.com
u/cmhbob — 22 days ago

Political posts

Political posts are welcome, especially as we approach primaries and critical mid-terms.

Those posts need to be something that encourages discussion, though, not unsupported claims and inflammatory AI-created images. If you've got an article that supports whatever claim you're making, then share a direct link to that article, not just the website. Use archive.ph/archive.today if you want to get past paywalls or otherwise preserve an article.

reddit.com
u/cmhbob — 1 month ago

Shelter for Sand Filter & Pump

Anyone done this? I'm in NE OK. It's pretty sunny here, and there's no shade around the pump. I'm thinking of putting together a little shade/cover over the pump to keep the sun off of it.

I'm not thinking of anything fancy. Treated 2x4s at the four corners with two taller than the other two to give a little slant to a treated plywood roof. Sound like it basically makes sense?

reddit.com
u/cmhbob — 1 month ago

Returning to the game

Recently been reminiscing about the game, which I used to play quite a bit, back in the Wren Weburg days.

Several computers later, I want to get back into the game. I've got my original SC4 and Rushhour CDs and keys, and a modern gaming machine. Do I need to just follow the ultimate Guide at Simtropolis to get things up and running?

(And I just found my Age of Empires CDs! And Zoo Tycoon!)

reddit.com
u/cmhbob — 1 month ago

Merilog for Tandem pumps

Anyone know if Merilog is approved by Tandem for the t:slim? The VA is switching me from Novolog.

reddit.com
u/cmhbob — 2 months ago

Regarding denaturalization

This came up on a FB post that mentioned several immigrants who'd been charged with (but not convicted of) various crimes, such that the DOJ was working to revoke their US citizenship.

I commented that that process needed to wait until they were convicted, because they were owed due process, but that I was in favor of deportation after conviction and service of sentence.

Another person asked, > ok but where would you deport them? More than likely they had to give up citizenship to become a US citizen. You don’t automatically get it back, so the country they came from no longer has to accept them and therefore they’d be stateless. If they committed a crime here they should be tried here and serve their sentence here just like any other American. If they are trying to denaturalize them after they’ve already been convicted and served their sentence there is no reason to denaturalize them. They’ve already been punished and should be treated like anyone else that’s been convicted and served their sentence.

So this raised some questions for me and I thought to start my research here.

  1. If a naturalized US citizen is deported, where are they sent? I know most recently, deportees are sent seemingly helter-skelter wherever the Feds feel like. The article in question said the people were from Iraq, Colombia, Morocco, Somalia, Gambia, Bolivia, Uzbekistan, Kenya, India, China, and Nigeria. Putting aside any possible risks to these particular citizens, are denaturalized people generally returned to their country of origin?

  2. Do those countries of origin generally restore citizenship to people who immigrated to the US?

  3. Does the US generally restore citizenship to people who emigrated from the US, thus renouncing their US citizenship, if those people are deported from their new home and returned to the US?

  4. How do other countries deport people? Are they on their own to get somewhere ("I don't care where you go, but you can't stay here.") Or does the deporting country put them on a flight back to the US at the person's expense?

reddit.com
u/cmhbob — 2 months ago
▲ 16 r/tulsa

Repairing your storm-damaged veggie garden

Green Valley Nursery LLC in Claremore is offering a free flat of fruit and/or vegetable starts (while supplies last) if you bring them a photo of the damage.

https://ibb.co/4wg9tppY

u/cmhbob — 2 months ago