Median IFS

[alanhather]

Hi all,

I'm trying to do a multiple if formula to median response times without counting any blank cells and cells with errors as not all them teams fill in the detail straight away. Here is a sample table

[TABLE="width: 413"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Team[/TD]
[TD]Date[/TD]
[TD]Respose Date[/TD]
[TD]Response Level[/TD]
[TD]Respose Time[/TD]
[/TR]
[TR]
[TD]Team 1[/TD]
[TD="align: right"]01/01/2018[/TD]
[TD="align: right"]01/01/2018[/TD]
[TD]<1 Hour[/TD]
[TD="align: right"]10:00[/TD]
[/TR]
[TR]
[TD]Team 2[/TD]
[TD="align: right"]02/01/2018[/TD]
[TD="align: right"]03/01/2018[/TD]
[TD]1-24 Hour[/TD]
[TD="align: right"]11:00[/TD]
[/TR]
[TR]
[TD]Team 3[/TD]
[TD="align: right"]02/02/2018[/TD]
[TD="align: right"]03/02/2018[/TD]
[TD]>24 Hour[/TD]
[TD="align: right"]03:02[/TD]
[/TR]
[TR]
[TD]Team 1[/TD]
[TD="align: right"]09/01/2018[/TD]
[TD="align: right"]09/01/2018[/TD]
[TD]<1 Hour[/TD]
[TD="align: right"]10:00[/TD]
[/TR]
[TR]
[TD]Team 4[/TD]
[TD="align: right"]01/01/2018[/TD]
[TD="align: right"]01/01/2018[/TD]
[TD]>24 Hour[/TD]
[TD="align: right"]15:00[/TD]
[/TR]
</tbody>[/TABLE]

My conditions are between Jan and I have a helper column that has been created by taking the date away from response date. i want median the response time.

thanks in advance