View Single Post
 
Old 01-31-2018, 02:47 PM
jrs3051 jrs3051 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jan 2018
Posts: 2
jrs3051 is on a distinguished road
Smile 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.
Reply With Quote