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