|
|
#1
09-14-2015, 10:47 PM
|
|||
|
|||
Calculate the progress per day
Hello Community!
I have a big problem. I want to calculate the progress per day (2015-3-12 06:00 to 2015-3-13 06:00). I tried this with vlookup(), that worked very well, but when at some dates arent any lengths (C80 : D96; C140 : D150), then it gives me the wrong progress. Do you know a formular how to ignore the "0"? The mistake in my example is from 14.3.2015 04:15 to 14.3.2015 08:00! please can you help me? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 how to add progress bar to the following vba
|
sivasucmc | Word VBA | 2 | 07-27-2014 04:44 PM |
| Time Remaining Progress Bar | teza2k06 | Excel | 1 | 05-13-2014 05:41 AM |
| Data Bars(Progress bar) | teza2k06 | Excel | 0 | 01-30-2014 11:59 AM |
|
updating task progress
|
ketanco | Project | 1 | 08-16-2012 05:09 AM |
| How to create a progress bar | AfterLife6 | Excel | 1 | 07-31-2012 08:43 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode