Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home

automatic time formula

Posted by Ignacio on September 05, 2001 10:21 PM
I am trying to find the way to get a formula that will give me the time updating the time just like a clock. then, i want to find another formula that by substracting the actual time minus the 23:59 will give me the housr remaining for that day.

example

actual time total hours in a day hours remaining
17:00 24 6.59 hours
=now() 24 =[now()]- 24
I did try this and many other ways but with no nosuccess. also the now() does not changes automatically. what am I doing wrong or not doing that this formulations dont work?
could you please help

Thank you
Ignacio


Re: automatic time formula

Posted by Henry Root on September 06, 2001 4:47 AM


Have a look at Active_Clock at :-
http://geocities.com/aaronblood/pages/vba.html

If you also want a cell to continually show the updated time remaining until midnight, put the following formula in a cell on the worksheet obtained from the above site :-
=(DATE(YEAR(C3),MONTH(C3)+1,1)-1/86400)-C3


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.