Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Base-75 formula?

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I did use ctrl-shft-ent. I copied the formula (minus {} outside braces). My cell positions are F2:G2, that's the only difference.
    Then change the formula to...

    {=SUM((TRUNC(F2:G2)*75+MOD(F2:G2,1)*100)*{-1,1})}

    ...the orientation of the array constant, {-1,1}, must match the orientation of your cell reference, F2:G2. In an array constant rows are delimited by commas (,) and columns are delimited by semicolons (.

    [ This Message was edited by: Mark W. on 2002-03-15 11:33 ]

  2. #12
    New Member
    Join Date
    Mar 2002
    Location
    Rick Trankle
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-15 11:30, Mark W. wrote:
    . . . F2:G2. In an array constant rows are delimited by commas (,) and columns are delimited by semicolons (.
    Thanks for the great tips and help.

    If I can bother you for one other thing . . .
    The Seconds side of my sec.fr result is turning into Minutes (never gets to Hours). So 102.45 should read 1.42.45.

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-16 04:27, rickeyjt wrote:
    On 2002-03-15 11:30, Mark W. wrote:
    . . . F2:G2. In an array constant rows are delimited by commas (,) and columns are delimited by semicolons (.
    Thanks for the great tips and help.

    If I can bother you for one other thing . . .
    The Seconds side of my sec.fr result is turning into Minutes (never gets to Hours). So 102.45 should read 1.42.45.
    =TRUNC(C1/4500)&"."&MOD(TRUNC(C1/75),60)&"."&RIGHT(ROUND(MOD(C1/75,1)*0.75,2),2)

  4. #14
    New Member
    Join Date
    Mar 2002
    Location
    Rick Trankle
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-18 08:43, Mark W. wrote:
    =TRUNC(C1/4500)&"."&MOD(TRUNC(C1/75),60)&"."&RIGHT(ROUND(MOD(C1/75,1)*0.75,2),2)
    This yields the numbers as expected. But occasionally, not all, there is an extra dot separator before the frames number, e.g., 4.3..3 or 5.17..3 which occur whether the cell is formatted Number or General. Also, some numbers get formatted with leading zeros (I would prefer that) and some not, e.g., 12.28.06, 11.57.0 or 17.7..6.

    Is there something to add to the formula to ensure a two digit format for the seconds.frames? Cell format does not help.

  5. #15
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry about the earlier shortcomings. Try this...

    =TRUNC(C1/4500)&"."&TEXT(MOD(TRUNC(C1/75),60),"00")&TEXT(ROUND(MOD(C1/75,1)*0.75,2),".00")

  6. #16
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-15 11:30, Mark W. wrote:
    In an array constant rows are delimited by commas (,) and columns are delimited by semicolons (.
    Hey Mark,

    wasn't aware of that - that's handy to know

    thanks
    Chris

  7. #17
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-20 11:35, Chris Davison wrote:
    On 2002-03-15 11:30, Mark W. wrote:
    In an array constant rows are delimited by commas (,) and columns are delimited by semicolons (.
    Hey Mark,

    wasn't aware of that - that's handy to know

    thanks
    Chris
    [img]/board/images/smiles/icon_smile.gif[/img]
    Oops! In the rush to respond I got it "bass ackward"

    {1,2,3,4} is a horizonal array so commas delimit columns

    {1;2;3} is a vertical array where semicolons delimit rows

    Sorry, for the misinformation.

  8. #18
    New Member
    Join Date
    Mar 2002
    Location
    Rick Trankle
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =TRUNC(C1/4500)&"."&TEXT(MOD(TRUNC(C1/75),60),"00")&TEXT(ROUND(MOD(C1/75,1)*0.75,2),".00")
    This worked great. Thanks. If you want to see it you can download it ftp from dviews.com/annonymous login - asd.xls. Sheet 1 lets me enter start/end points and sheet 2 I can change the frame numbers of the difference between start and end points.

    I needed this app for a music slow down program for doing transcriptions (Amazing Slow Downer - http://www.ronimusic.com). I define what one measure is then I can reposition the slider to move through the song one, two, three or four measures at a time.

    Rick

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •