Round Error Decimal 2 points

[zalik22]

Hi,

I am trying to display 2 decimals and convert seconds to minutes. So I have =round(t1/60,2). If t1=26, formula works but if t1=24, formula displays 0.4 instead of 0.40. I am concatenating this value to read something like "Time is 0.40 minutes". Any way to get it to show 0.40 instead of just 0.4? Thanks!

 

[Eric W]

How about:

Book1
	T	U
1	24	Time is 0.40 minutes
2	26	Time is 0.43 minutes
Sheet1

Cell Formulas
Range	Formula
U1:U2	U1	="Time is "&TEXT(ROUND(T1/60,2),"0.00")&" minutes"

 

[zalik22]

Thanks so much, it worked!