Excel Days between Dates in a Table

[funcppl5]

I have a Excel Table, I am trying to get the amount of days between to dates but per individual unit.

Unfortunately I can not download a picture so I will try to describe it.

In Column A I have PLUG I.D. (these are Numbers or Letters)
In Column B I have SETTING DATE
In Column C I want TIME BETWEEN SETTING

Say in A1 I Have Plug "L" set on 1/01/2017
and in A20 is the next Plug "L" and it was set on 2/15/2017
and there are multiple other plugs set between these dates, but I would like them all to go off the Plug I.D.

I have tried DATEDIF function and it works until you filter the list by PLUG I.D.

I would really appreciate any help I could get.
Have a great day
Shawn

 

[DILIPandey]

Hi Shawn, with your example, enter below formula in C20:-

=B20-MAX(IF($A$1:$A$19="L",$B$1:$B$19,""))

Confirm with ctrl shift enter, not just enter and format C20 as General.

Regards,
DILIPandey

 

[funcppl5]

Thank you for your reply DILIPandey.

When you are looking in Cloumn A for the individual Plug ID ("L") do you know how to make it adjustable?

Thank you

 

[DILIPandey]

do you know how to make it adjustable?

I did'nt get that, please explain. Thx


Regards,
DILIPandey