Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2016, 03:59 PM
macropod's Avatar
macropod macropod is offline Time to digital minutes Windows 7 64bit Time to digital minutes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,514
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Time to digital minutes Why only 3 minutes audio recording rfwltd OneNote 1 10-29-2016 01:42 PM
Time to digital minutes 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
Time to digital minutes Documents Take 5 Minutes To Open Farrar Word 1 07-23-2007 02:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:01 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