Keeping only the decimal?

[gannon_w]

So I actually have time entered as a number and decimal.

10.29 means 10 minutes and 29 seconds. How can I get that to only seconds 629?

[AndyLitch]

=(60*value(left(a1,2))+value(right(a1,2)))

or

=RIGHT(A1,LEN(A1)-FIND(".",A1,1))+60*VALUE(LEFT(A1,FIND(".",A1,1)-1))

[oeldere]

Please Login or Register  to view this content.

[Kevin UK]

Hi gannon_w

Assuming data is in A1
=INT(A1)*60+MOD(A1,1)*100