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?
