Increment Formula With If Statement

[Spaggiari]

Hey everyone, I'd like to know, if its possible, how to increment a formula with an If statement that transforms 2 values in time format and then as long as these two values keep beeing added in the cells the formula keeps active in the column.

I tried to apply the code for all the but this makes my file huge like 20MB!

You can check this on the file, go the "records" sheet, add the time in the "shift start" and "shift end" fields, then the difference value goes to "hours" in the sheet.

https://www.dropbox.com/s/ouda3vdcu0buefh/project.xlsm

​

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showthread.php?651897-Increment-Formula-With-If-Statement

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).