Thread: [Solved] converting mm.s format to mm:ss
View Single Post
 
Old 10-26-2012, 11:42 PM
macropod's Avatar
macropod macropod is online now 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
Kevin,

Your answer pre-supposes that the decimal part is a fraction of a minute, which may or may not be the case. Works fine if 1.25 represents 1 minute & 15 seconds, but not if it represents 1 minute & 25 seconds. That's why I asked the question.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote