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.


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

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

Have a look at Active_Clock at :-

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 :-