Converting 100's to minutes and seconds

[Ckirkpatrick]

I am a stand-up comic and have a numeric field (JOKETIME) that I'm entering the time it takes to perform a particular joke. And then I have a "total"field for the total time for a group of jokes. How do I convert the total of "8.95" for instance into minutes and seconds? Your help would be appreciated!

[Steve Workings]

Re: Converting 100's to minutes and seconds

I have no doubt there's a simpler way, but here's one, and I'm assuming your total time -- ntime field below -- is numeric:

ntime = 8.95
realtime = ltrim(str(int(ntime))) + ":" + padl(ltrim(str(((val(right(ltrim(str(ntime,5,2)),2)) * 60) / 100))),2,"0")
?realtime
= "8:57"

[GGandhi]

Re: Converting 100's to minutes and seconds

steve gave you perfect answer.
i am just curious how you got the number 8.95.

total of "8.95"

in other words, what will be the duration of each individual jokes?
i would have thought
8.95 = 14 minutes and 55 secs
minutes = int(895/60)
seconds = mod(895, 60)

total_duaration_of_jokes = int(895/60)+":"+mod(895,60)

or a general formula would be

total_duration_of_jokes = int(total_time_in_seconds / 60)+":"+mod(total_time_in_seconds,60)

[G Gabriel]

Re: Converting 100's to minutes and seconds

Is 8.95 a number of minutes?
It can't possibly be hours! I hope not....but could be seconds..say the time for one joke..
But if it is the number of minutes, then all you need is to convert the decimal into seconds, you already have the minutes.
So, what is it?
It's never funny when people ask obscure questions.

[G Gabriel]

Re: Converting 100's to minutes and seconds

Working with the assumption that it is minutes:

joke_time=8.95
?int(joke_time)+":"+(joke_time-int(joke_time))*60
= "8:57"

?int(joke_time)+" minutes and "+(joke_time-int(joke_time))*60+" seconds"
= "8 minutes and 57 seconds"

[Steve Workings]

Re: Converting 100's to minutes and seconds

joke_time=8.95
?int(joke_time)+":"+(joke_time-int(joke_time))*60
= "8:57"

This doesn't produce what he wants if the first minutes are less than 10. For instance:

joke_time=8.05
?int(joke_time)+":"+(joke_time-int(joke_time))*60
= "8:3.000000000000043"

[G Gabriel]

Re: Converting 100's to minutes and seconds

That is the correct answer.
5% of a minute is 3 seconds.
I don't know what format he wants the output in, so I provided couple different ones.
Here is another:

joke_time=8.05
?int(joke_time)+":"+padl(""+int((joke_time-int(joke_time))*60),2,"0")
= "8:03"

Incidentally, in my system, the answer is slightly different:

joke_time=8.05
?int(joke_time)+":"+(joke_time-int(joke_time))*60
= "8:3.00000000000004"

[Ckirkpatrick]

Re: Converting 100's to minutes and seconds

Steve, it worked perfectly! Thanks a bunch!

It was 8 minutes 95 seconds before converting :)

[G Gabriel]

Re: Converting 100's to minutes and seconds

It was 8 minutes 95 seconds before converting :)

??
Was it?
So, what was converted to what?
converted from 8 minutes 95 sec to 8 min 57 sec!?

[Ckirkpatrick]

Re: Converting 100's to minutes and seconds

I don't know as I had already added more jokes with times before I added the formula :(

[G Gabriel]

Re: Converting 100's to minutes and seconds

OK..I am at total loss here..so maybe I just don't get the joke.

[gmeredith17]

Re: Converting 100's to minutes and seconds

Chuck, I think you need to explain how you calculated the 8.95 total. What are you using to time it that produces this number?

Is it really 8min 95 secs? If it is then Steve's solution isn't going to work for you.

Or is it 8 minutes and 0.95 of a minute. In which case Steve's solution will work for you.

Gabriel is right you need to provide more detail to ensure your given the correct solution.

[madtowng]

Re: Converting 100's to minutes and seconds

8 minutes 95 seconds sounds like it should be 9 minutes 35 seconds.

[Ckirkpatrick]

Re: Converting 100's to minutes and seconds

Sorry for just getting back to this. For example I have 5 jokes entered, and each joke is timed. Joke 1 is 38 seconds, Joke 2 is 1 minute 15 seconds, joke 3 is 41 seconds, and joke 4 is 22 seconds and joke 5 is 1 minute 11 seconds and those times are entered into a numeric field. They all total 247 seconds. How do I convert that to minutes and seconds?

[Steve Workings]

Re: Converting 100's to minutes and seconds

TotalSeconds = 247
Minutes_Seconds = ltrim(str(round(TotalSeconds / 60,0))) + ":" + padl(ltrim(str(mod(TotalSeconds,60))),2, "0")
msgbox(Minutes_Seconds)