Calculating time difference per task over 2 days

[Jess9898]

Hi,
I am trying to figure out how to find the difference between two task times as long as their ID number is the same. This is for different shifts/days so when their shifts ends at 3AM and starts back at 4PM the next day I don't want to take the 12 hour time difference - I want it to say 0. I also don't want a negative time error when it switches over to midnight the next day. Attached are 2 screens shots to get a better idea of what I'm asking.

At the most basic form, I have this =IF(E5=E4,C5-C4,0)

B = Date
C= Time (Military - but can change)
D = Difference
E = ID number

Any help would be appreciated!

 

[JamesCanale]

Column A looks like what you want to use, since you don't have to worry about midnight turnover.

=IF(E5=E4,IF(A5-A4<0.25,A5-A4,0),0)

The 0.25 represents 6 hours, so if the gap is more than six hours, it will give a zero.

 

[Jess9898]

Column A looks like what you want to use, since you don't have to worry about midnight turnover.

=IF(E5=E4,IF(A5-A4<0.25,A5-A4,0),0)

The 0.25 represents 6 hours, so if the gap is more than six hours, it will give a zero.

That worked thank you !!!