# Calculate difference if there is a change in certain cell

1. ## 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.  Register To Reply

2. ## Re: Calculate difference if there is a change in certain cell

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

3. ## Re: Calculate difference if there is a change in certain cell 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?  Register To Reply

4. ## Re: Calculate difference if there is a change in certain cell

It appears your formula already does that, am I missing something? oh..I see it now, perhaps this?

IF(VALUE(E3)<VALUE(E2),0,(G3-G2)*24)  Register To Reply

5. ## Re: Calculate difference if there is a change in certain cell

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.  Register To Reply

6. ## Re: Calculate difference if there is a change in certain cell

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

7. ## Re: Calculate difference if there is a change in certain cell

Perfect, thanks a lot!!  Register To Reply

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1