Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-31-2018, 02:47 PM
jrs3051 jrs3051 is offline Calculating Turnaround time over multiple tests Windows 7 64bit Calculating Turnaround time over multiple tests Office 2010 64bit
Novice
Calculating Turnaround time over multiple tests
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Turnaround time over multiple tests Index using multiple conditional tests RLS41155 Excel 2 12-02-2015 04:59 AM
Calculating Turnaround time over multiple tests 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 over multiple tests Calculating Turnaround Time shstone Excel 4 12-11-2014 12:39 PM
Calculating Turnaround time over multiple tests Calculating turnaround times in excel Swooshy Excel 14 11-21-2013 01:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft