• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Countdown Timer

J

Jym396

New Member
Greetings,

OK, I like to struggle with formulas...but I'm saying uncle. I have sort of a timesheet workbook with a start and stop time. I'm just trying to count down the time until I have to go to work and then count down the time until I am done. If I use a hard coded time and simply subtract it works fine, but if I introduce the =now function, it does not work. Assume the following data starts in cell A1,I left out the headings as to make it simpler:


7:15 AM 3:45 PM
 
Check out here:

http://www.ehow.com/how_5052033_insert-timer-ms-excel.html


or here:

http://www.excelforum.com/excel-general/680996-creating-a-countdown-timer-on-excel.html
 
Thanks Luke,

Would have never come up with that. Pretty much a babe-in-the-woods with VBA. Enrolled in Chandoo's class...long way to go. Still don't understand why the =now function acts differently than a hard coded date. Thanks again. -Jim
 
Glad to have you as a part of the community. =)


The NOW function, and any other formula, is only updated when the workbook is recalculated. If you don't have anything else happening in the workbook, the formula will never update.


Also, the NOW function gives date & time, the TODAY function gives current date, and a hard coded date will only and forever only display the date that was entered.
 
Thanks for the welcome Luke ;)

Yeah, I was recalculating the workbook and also noticed when the NOW function cell is formatted to NUMBER, the excel serial date number is returned. Whereas a hard coded date returns a decimal number. Should've figured that one out. Answers completely that NOW returns the date and time. Thanks again. -Jim
 
You must log in or register to reply here.
Back
Top