Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-15-2015, 07:59 AM
gebobs gebobs is offline Calculate the progress per day Windows 7 64bit Calculate the progress per day Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Trying to parse this out. There are a few questions regarding the data:

* Your first set of equations is looking for a start of 2015-03-12 06:00 and an end of 2015-03-13 06:00. For the start, there are two identical cells right at the top. For the end, there are also two cells though they are not consecutive (B68 and B51).

* The measurement intervals seem to vary widely, any where from 15 to 480 minutes. Is that right?

* Lastly, there seem to be quite a few duplicates.

At any rate, I guess the problem with the third is that the zero data are some kind of mistake or something like that, correct? So, in that case, you want it to use the previous data of 8.8. Is that right?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate the progress per day 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
Calculate the progress per day 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:00 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft