Loading ...
Sorry, an error occurred while loading the content.

Re: [Clip] Convert TIME

Expand Messages
  • Bob McAllister
    ... ^$CALC((^&*60)DIV60;0)$ minutes ^$CALC((^&*60)MOD60;0)$ seconds will replace a selected decimal representation of minutes (represented her by ^&) with the
    Message 1 of 3 , May 3 4:31 PM
    • 0 Attachment
      On Tue, May 4, 2010 at 8:53 AM, bozlawless <bozlawless@...> wrote:
      > Is there a way to convert 2.3333 to 2 Minutes 20 Seconds
      >
      > OR 6.500 to 6 Minutes 30 Seconds etc
      >

      ^$CALC((^&*60)DIV60;0)$ minutes ^$CALC((^&*60)MOD60;0)$ seconds

      will replace a selected decimal representation of minutes (represented
      her by ^&) with the corresponding minutes and seconds rounded down to
      a whole second. (So note that 2.3333 returns 2 minutes 19 seconds not
      2 minutes 20 seconds - you need 2.333334 for that.)

      Bob McAllister
    Your message has been successfully submitted and would be delivered to recipients shortly.