Thanks:  0
Likes:  0

1. 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. 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. 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. 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. 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. 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. 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. =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

## User Tag List

#### Posting Permissions

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