remaining hours until noon of next day...

[rickblunt]

Hey there, got a head scratcher that I thought would be easy but I failing miserably at - lol... I have a worksheet where I am recording some data each day, the date and time of the inspection is in column A, so for example A156 is "4/21/2021 3:18:28 AM". I need to know the remaining hours until noon of the next day. Thought this would be easy, I am thinking that I need to get to A156 plus midnight of the next day, and then subtract 12 hours, then subtract out that value from A156. But I can't seem to get the syntax correct on the formula so I am guessing that I am going completely in the wrong direction. Does anyone have any thoughts on how to do this?
Thank you,

 

[jtakw]

Hi,

Try this:

Book3.xlsx
	A	B	C
1	4/21/2021 3:18:28 AM		32:41
Sheet917

Cell Formulas
Range	Formula
C1	C1	=INT(A1)+1.5-A1

Edit: forgot to custom format result cell-->> [h]:mm

 

[rickblunt]

OH! INT - I hadn't thought about that one, I was doing it the hard way, the really hard way apparently - lol. Thank you so much, that worked great - and I learned some more stuff

 

[jtakw]

You're very welcome, thanks for the feedback.