format Excel timestamp

Asked

Viewed 125 times

-1

Is there any formula in excel for formatting in the timestamp column and move to 1 column type time which is the value that interests me.

inserir a descrição da imagem aqui

excel libreoffice

1 answer

0

With Tue Apr 23 2019 11:49:21 GMT+0100 (GMT+01:00) in A2.

The following function:

=TEXTO(EXT.TEXTO($A2;LOCALIZAR(":";$A2)-2;8);"hh:mm:ss")

Returns:

Resultado

  • Insert the formula in A2?

  • In another column/cell, in A2 is the original data

Browser other questions tagged excel libreoffice

You are not signed in. Login or sign up in order to post.