I’ve created an excel worksheet, and I’m trying to track the time that it takes to finish a project. My problem is that I need to see a running (real-time) clock that shows the days elapsed between the time the person starts the project “Start Date” (signified by them entering a start date, month/day/yr), and the time that they finish the project “Completion date.” (signified by the person entering an End date, month/day/yr).
Once the person completes the project, and enters the “Completion date.” The timer needs to stop, and retain the number of elapsed days.
It would be nice if the real-time counter is formatted to display in Days, Hours, and minutes. I also want to avoid getting error messages when either cell is empty. Is this something that you can help me with? Thanks.
Years, Months, Days, Hours, Minutes, Seconds.
Again,
Put your Start Date in cell B1
Put your End Date in cell D1
Put the below formula in F1
This is all one formula:
=IF(D1=””,DATEDIF(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”y”)&” years, “&DATEDIF;(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”ym”)&” months, “&DATEDIF;(B1,NOW()-(MOD(B1,1)>MOD(NOW(),1)),”md”)&” days, “&TEXT;(MOD(NOW()-B1,1),”hh “” hours, “” mm “” minutes, and “” ss “”seconds”””),DATEDIF(B1,D1-(MOD(B1,1)>MOD(D1,1)),”y”)&” years, “&DATEDIF;(B1,D1-(MOD(B1,1)>MOD(D1,1)),”ym”)&” months, “&DATEDIF;(B1,D1-(MOD(B1,1)>MOD(D1,1)),”md”)&” days, “&TEXT;(MOD(D1-B1,1),”hh “” hours, “” mm “” minutes, and “” ss “”seconds”””))
You’d best copy and paste.
MIKE
http://www.skeptic.com/