Thread: [Solved] Time to digital minutes
View Single Post
 
Old 11-24-2016, 03:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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