![]() |
|
#7
|
||||
|
||||
|
In K2 try =D2*60/I2 and pull down as needed. As your time is expressed in decimal the conversion to time is annihilated by the conversion of 60 minutes to time;
BTW the use of SUM is not necessary in this case
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
| Tags |
| minutes turnaround time |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a formula to calculate turnaround time | Rockitman31 | Excel | 9 | 09-07-2015 09:41 AM |
Calculating turnaround times in excel
|
Swooshy | Excel | 14 | 11-21-2013 01:04 PM |
| OPK for Volume License Version? | beems | Office | 0 | 01-11-2013 02:15 PM |
| Pivot Tables - Values divided by Subtotal | Loretti | Excel | 0 | 11-12-2012 02:15 PM |
| MS office 2010 Professional Plus Volume Activation | sksathish19 | Office | 0 | 03-03-2011 10:37 AM |