MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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