decimal point in worksheet

[Russ]

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/rwpatterson357/temp/test.xls

thanks,
russ

 

[Trevor Shuttleworth]

Russ

one way:

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

Regards

Trevor

 

[JE McGimpsey]

One way:

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

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

 

[Russ]

Thank you both for nice solutions. Both work equally well.

sincerely,
russ