[RESOLVED] 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

Thx in advance!

[Spaggiari]

Anyone?

[westconn1]

i am guessing here a bit, as you description is not really clear

you can put code into the worksheet change event, probably for the shift end column, that will insert the formula, when the value is in the first column changes

[Spaggiari]

This is what I came up with, created a table and applied a formula to the fields and its working fine.

You can take a look here https://www.dropbox.com/s/qb2m9a7a6a...project.xlsm?m

Ty