![]() |
#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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
RLS41155 | Excel | 2 | 12-02-2015 04:59 AM |
![]() |
Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
Measuring Turnaround Time | quirkycanuck | Outlook | 0 | 03-03-2015 01:22 PM |
![]() |
shstone | Excel | 4 | 12-11-2014 12:39 PM |
![]() |
Swooshy | Excel | 14 | 11-21-2013 01:04 PM |