#1
|
|||
|
|||
Calculating Turnaround time over multiple tests
I am trying to figure out how to calculate turnaround time in excel.
For example: Sample 1 - submitted on 01/05/2018 (cell A1) Test 1 - Completed on 01/07/2018 (Cell B1) Test 2 - Completed on 01/15/2018 (Cell C1) Test 3 - Completed on 01/08/2018 (Cell D1) I want to calculate the overall number of days taken from sample submission date to last test date, however i need the formula to automatically capture the latest date between cells B1 to D1. |
#2
|
|||
|
|||
=lookup(2,1/(b1:d1=max(b1:d1)),b1:d1)
|
#3
|
|||
|
|||
=MAX(B1, C1, D1)-A1
Excel treats dates as numbers with +1 being an extra day, so this will get you the number of calendar days between submission and the last test. It gets somewhat more complex if you need business days or something, but for calendar days it's really easy. |
#4
|
|||
|
|||
Thank you Alsadius your formula worked perfectly for what I needed.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Index using multiple conditional tests | RLS41155 | Excel | 2 | 12-02-2015 04:59 AM |
Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
Measuring Turnaround Time | quirkycanuck | Outlook | 0 | 03-03-2015 01:22 PM |
Calculating Turnaround Time | shstone | Excel | 4 | 12-11-2014 12:39 PM |
Calculating turnaround times in excel | Swooshy | Excel | 14 | 11-21-2013 01:04 PM |