Finding Midnight
Posted by Alan Villiers on January 03, 2002 10:45 AM
I'm stumped. I need to take a date and time; i.e.
01/03/02 12:46 and calculate how many hours & minutes until midnight 01/04/02. My dates/times will be different for each occurrance.
Ideas?
Posted by Dan on January 03, 2002 10:53 AM
If your date is in A1 put this formula in B1:
=(INT(A1)+1)-A1
And format B1 as [h]:mm:ss
HTH.
Posted by Alan Villiers on January 03, 2002 12:11 PM
This works well and thanks! Elegant solution too.
-av-
