how to make a time to completion chart

Question

i need to make charts on excel

Answer 1

A1 : user-entered Complete-By Date (I entered 9/30/2015)

B1 : =NOW()

C1 : =A1-B1

D1 : =TEXT(C1,"m")&" months, "&TEXT(C1,"d")&" days, "&TEXT(C1,"h")&" hours, "&RIGHT(TEXT(C1,"h:mm"),2)&" minutes"

 

On 7/3/2015 at 9:58PM my output was:

                                      3 months, 28 days, 2 hours, 02 minutes

 

You can play with the formatting and adjust it to suit your needs.  By the way, Denise from Whitney TX, I taught high school math in Whitney for 2 years (not at that nice new high school on FM933 - the old one that was on San Jacinto St).

Answer 2

Hi the steps take a couple of minutes but this should help you. 

In A1 enter the date and time you want to finish your project 
In A2: =now()
In A3: ="Months " & DATEDIF(A2,A1,"m")
In A4: =" Days " & DATEDIF(A2,A1,"md")
In A5: =" Hours " &TEXT(A1-A2,"hh")
In A6: =" Minutes "&TEXT(A1-A2,"mm")
In A7: =" Seconds "&TEXT(A1-A2,"ss")

In A8: =A3&A4&A5&A6&A7 After you have these steps done you will want to make it so that the time countsdown in real time so you that you do not have to close and open it over and over again. to do that press the ALT F8 key combination, enter aaa in the macro name, then press edit. This will open the VB editor and give the sub outline headings you will see Sub aaa() and End Sub what you type in you want to look like this

Sub aaa()
Application.Calculate
Application.OnTime Now() + TimeValue("00:00:01"), "aaa"
End Sub

Once you have that input close it and go back to the excel sheet. Press alt F8 again and this time select the macro you created and click run. The timer will then start counting down from current time and will continue. If you want to make it into a chart simply select the cells that you put information in and go to insert , then selet the chart you want. A word of note however is that when you turn this information into a chart it will not have anything that moves in it. If you are trying to juct make a regular chart input your data in the cells then use the same steps as you would once you finished your countdown timer, select your cells with information then go to insert and select the chart you want. I hope this is useful.