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 Team Date Respose Date Response Level Respose Time Team 1 01/01/2018 01/01/2018 24 Hour 03:02 Team 1 09/01/2018 09/01/2018 24 Hour 15:00 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

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Median IFS

Thread starter alanhather
Start date Apr 12, 2018
Tags

date median response respose team

alanhather

New Member

Apr 12, 2018

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

Team	Date	Respose Date	Response Level	Respose Time
Team 1	01/01/2018	01/01/2018	<1 Hour	10:00
Team 2	02/01/2018	03/01/2018	1-24 Hour	11:00
Team 3	02/02/2018	03/02/2018	>24 Hour	03:02
Team 1	09/01/2018	09/01/2018	<1 Hour	10:00
Team 4	01/01/2018	01/01/2018	>24 Hour	15:00

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