decimal point in worksheet

Y'all:

I have a spreadsheet where I want to display a time as "min:sec". My
worksheet formula for this is =INT(C2) & ":" & INT((C2-INT(C2))*60)

No problem. Except that I want it to display like this: "30:03", not
"30:3". How can I do this?


e.g.
Here is what I get:
Time (minutes) Time (minutes:seconds)
30.050 30:3

Here is what I want:
Time (minutes) Time (minutes:seconds)
30.050 30:03


I put the spreadsheet out on my website at
http://webpages.charter.net/rwpatter.../temp/test.xls

thanks,
russ

One way:

XL calculates times as fractional days, so to get minutes, divide by
(60*24), and format accordingly:

=TEXT(C2/1440,"[m]:ss")



In article <[email protected]>,
"Russ" <[email protected]> wrote:

> Y'all:
>
> I have a spreadsheet where I want to display a time as "min:sec". My
> worksheet formula for this is =INT(C2) & ":" & INT((C2-INT(C2))*60)
>
> No problem. Except that I want it to display like this: "30:03", not
> "30:3". How can I do this?
>
>
> e.g.
> Here is what I get:
> Time (minutes) Time (minutes:seconds)
> 30.050 30:3
>
> Here is what I want:
> Time (minutes) Time (minutes:seconds)
> 30.050 30:03
>
>
> I put the spreadsheet out on my website at
> http://webpages.charter.net/rwpatter.../temp/test.xls
>
> thanks,
> russ

Russ

one way:

=INT(C2) & ":" & TEXT(INT((C2-INT(C2))*60),"00")

Regards

Trevor


"Russ" <[email protected]> wrote in message
news:[email protected]...
> Y'all:
>
> I have a spreadsheet where I want to display a time as "min:sec". My
> worksheet formula for this is =INT(C2) & ":" & INT((C2-INT(C2))*60)
>
> No problem. Except that I want it to display like this: "30:03", not
> "30:3". How can I do this?
>
>
> e.g.
> Here is what I get:
> Time (minutes) Time (minutes:seconds)
> 30.050 30:3
>
> Here is what I want:
> Time (minutes) Time (minutes:seconds)
> 30.050 30:03
>
>
> I put the spreadsheet out on my website at
> http://webpages.charter.net/rwpatter.../temp/test.xls
>
> thanks,
> russ
>

Thank you both for nice solutions. Both work equally well. :-)

sincerely,
russ