![]() |
|
#1
|
|||
|
|||
|
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. |
|
|
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 |