Hi everyone,

i applied a filter to a column of data then want to find the difference in time between 2 cells (one above the other). problem is, applying the filter messes up the cell references.

after applying the filter, i use this formula for time difference between the 2 cells

=MOD(TEXT(G300,"00\:00")-TEXT(G299,"00\:00"),1)*1440

with the filter however, what happens is the cell references become jumbled, like

=MOD(TEXT(G300,"00\:00")-TEXT(G28,"00\:00"),1)*1440

does anyone know how i can force the cell references to be relative, even if i change the filter? thanks in advance!