Calculate difference if there is a change in certain cell

Hi all,

I was wondering if the following is possible:

-I want to calculate the time it takes to change "Depts" in the workbook attached.

Is there a formula I could use that would say if there is a change in the "Dept." column calculate the change in column G?

I have given the time difference formula I would like to use.

Any help would be appreciated.

is the change from the max time or min time? IE for shovel, do you want the change form g8-g2 or g8-g7?

Originally Posted by igoodable

is the change from the max time or min time? IE for shovel, do you want the change form g8-g2 or g8-g7?

G8-G7 please. Sorry about that

Oh sorry, I left an ifstatement in there, but no that didn't work. I want there to be nothing in the calculation column if there is no dept. change. So there wouldn't be any calculation till row 7 which would be calculating the time it takes to go from 10 to 20.

I believe this should work. =IF(E2<>E3,(G3-G2)*24,"")

Perfect, thanks a lot!!