How can i round down all the second decimal place in time format?

[ttt990]

I want to cut all the second decimal place and still remain first decimal.

Eg. (cells are in time format "hh:mm")
3:24 -----> 3:20
17:59 ----> 17:50
20:16 -----> 20:10

Is there any way i can do this?

 

[WarPigl3t]

Assuming 3:24 is in cell A1...
=Left(a1,Len(A1)-1)&"0"

 

[ttt990]

I've tried and it resulted 0.1416666666666670

<colgroup><col></colgroup><tbody>
</tbody>

 

[WarPigl3t]

=TEXT(LEFT(TEXT(A1,"h:mm"),LEN(TEXT(A1,"h:mm"))-1)&0,"h:mm")

 

[FormR]

Another option;

Note: you may need to format the cell containing the formula as time.

=FLOOR(A1,"00:10")

 

[ttt990]

Another option;

Note: you may need to format the cell containing the formula as time.

=FLOOR(A1,"00:10")

OMG it works perfectly!!! Thank you so much CHEERS....