Denise S.

asked • 09/08/12

how to make a time to completion chart

i need to make charts on excel

2 Answers By Expert Tutors

By:

JOHN F. answered • 07/03/15

Tutor
4 (4)

Getting you that job or raise by augmenting your skillset

Steven G. answered • 09/09/12

Tutor
5 (2)

Education Assistance

Denise S.

Thank you!

Report

09/09/12

Ian F.

You are good with Excel, my man! Spent hours on this one night, never could figure it out on my own. Thank you! Can we take it one step further and include the time on that date? I can't get the datedif() to calculate anything besides just the date.  How can I calculate between now and 5:00pm on a certain date ie the due date and time? I also ran into a problem where only the seconds increment or decrement.  I don't know how to fix this... pls help? thanks.

Ian F.

Report

09/13/12

Ian F.

I found that if you do the hours minutes and seconds in 1 cell it increments better.

I have it this way: in a5 =TEXT(A1-A2,"hh:mm:ss")

For some reason it wont increment properly, for me, if you have each hr, min, sec increment in their own cell. However =TEXT(A1-A2,"hh:mm:ss") seems to work like a charm.

Report

09/13/12

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.