MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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-