![]() |
|
|
|
#1
|
||||
|
||||
|
Once you adjust the formula I posted for your actual cell references (e.g. =LEFT(D3,8)*1440), it returns the correct results in all cases. You need to adjust your expectations - 46 seconds is 0.77 minutes, not 0.76 minutes.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Why only 3 minutes audio recording
|
rfwltd | OneNote | 1 | 10-29-2016 01:42 PM |
Calculate Average Time Elapsed in Days, hours and minutes
|
Nina46 | Excel | 9 | 09-11-2015 02:09 AM |
| turnaround time minutes divided by volume | tweeter | Excel | 9 | 11-18-2013 02:09 PM |
| Forward Unread Messages after X Minutes? | BamaBrad | Outlook | 2 | 03-13-2011 07:57 AM |
Documents Take 5 Minutes To Open
|
Farrar | Word | 1 | 07-23-2007 02:54 PM |