Hi all,
I am looking for an efficient way to calculate the error time from a sheet of data based on the name column (B).
When the value of a certain error is 1, the error is started and when the value is 0, the error is solved (column C).
There are a lot of different errors, which sometimes simultaneously are present (An earlier error is not solved yet, but the next error is already present).
Being inexperienced with Excel, this makes it difficult for me to extract the error times (time stamps in column D) without having to filter X amount of error names in order to successfully calculate the error times.
My question is, does anyone have a shout on an efficient line of code or macro which best handles what I wish to achieve?
(Office 365)
I am looking for an efficient way to calculate the error time from a sheet of data based on the name column (B).
When the value of a certain error is 1, the error is started and when the value is 0, the error is solved (column C).
There are a lot of different errors, which sometimes simultaneously are present (An earlier error is not solved yet, but the next error is already present).
Being inexperienced with Excel, this makes it difficult for me to extract the error times (time stamps in column D) without having to filter X amount of error names in order to successfully calculate the error times.
My question is, does anyone have a shout on an efficient line of code or macro which best handles what I wish to achieve?
(Office 365)