Home 
Search 
Today's Posts 
#1




Progressing the date one day forward if conditions of time are met:
This is a little complicated for me, so I'm asking for your help. I'm still learning Excel, but I can't seem to figure out the formula for this condition.
Purpose of Spreadsheet:  to accurately depict times and dates of checks needed when an incident occurs, starting at the time of the incident. (See attached photo) Function obtained:  I've managed to accurately formulate the timing of the schedule. So, the times are all good. All I have to do is set the Time of Incident, and it will automatically change all the times appropriately in the schedule between B10 and B26. This functions well. Functions needed: 1) Since midnight is random in the schedule, it is impossible to predict when the date will need to be changed in the A column to the next date. If, for example, the incident occurs at 14:20, then I would only want the date on the left of B19 to change by +1 day (in A19), since the time schedule would change to 00:20, as per the scheduled routine. 2) All of the time schedules do not have to be visible if there is no number in Q34. How do I go about making the time schedules in the B column invisible if there is no value in Q34? 
#2




Progressing the date one day forward if conditions of time are met:
Here's one approach.
... predict when the date will need to be changed in the A column to the next date. Presumably,  you already have a way to get the start date in A10, and  the time values in column B don't have the date included invisibly. In A11, put =IF(B11=B10,"",MAX(A$10:A10)+1) and copy down. ... making the time schedules in the B column invisible if there is no value in Q34 Since you are satisfied with your formulas in column B, they can be nested within an IF() to accomplish this: =IF($Q$34="","", [your_formula]) Presumably, the formula in B11 is already copied down to subsequent rows, so the update can proceed the same way, without editing each individual formula.  A different approach is to use conditional formatting. That way, the values are still in the cells, but (essentially) written with ink matching the background when needed to make them invisible. 
#3




Quote:
Quote:
Quote:
Quote:
A typical Formula for the "B" Column now looks something like this, with the times changed as needed per schedule: =IF($Q$34="","",B10+TIME(0,30,0)) <(Example Cell is B11) Once again, thanks for your help! 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
calculate 6 months forward from a date  Excel Discussion (Misc queries)  
Timeline Start date forward  Excel Worksheet Functions  
Date going forward  Excel Worksheet Functions  
Auto calculate for date + days forward to yield new date  Excel Worksheet Functions  
sum multiple rows based on progressing date field on each row  Excel Worksheet Functions 