Como combinar colunas de data e hora em uma coluna nas planilhas do Google?
Autor: Xiao YangÚltima modificação: 2022-07-20
Nas planilhas do Google, você precisa combinar a coluna de data e hora em uma coluna, como mostrado a seguir, como você poderia lidar com isso nas planilhas do Google?
Combine colunas de data e hora em uma coluna com fórmula
Para combinar as colunas de data e hora em uma coluna, a seguinte fórmula pode ajudá-lo:
1. Insira esta fórmula: =concatenate(text(A2,"mm/dd/yyyy")&" "&text(B2,"hh:mm:ss"))em uma célula em branco onde você deseja colocar o resultado combinado e pressione Entrar para obter a primeira célula combinada.
2. Em seguida, selecione a célula da fórmula e arraste a alça de preenchimento até as células que deseja combinar, e as colunas de data e hora foram combinadas em uma coluna, veja a captura de tela:
Melhores ferramentas de produtividade de escritório
Aprimore suas habilidades de Excel com o Kutools para Excel e experimente uma eficiência como nunca antes. Kutools para Excel oferece mais de 300 recursos avançados para aumentar a produtividade e economizar tempo. Clique aqui para obter o recurso que você mais precisa...
This comment was minimized by the moderator on the site
Same error to me
It doesn't work. I do not understand the message below. I don't need it explained to me. I just need a formula that works please. Thank you.
"There's a problem with this formula.
When trying to insert the formula Excel replies:
If you type: =1=1, cell shows : 2
To get around this, type an apostrphe (') first:
But if you type: '=1=1, cell shows: =1+1"
Why ?
This comment was minimized by the moderator on the site
I get the result like: 01/10/yyyy 14:15:00.000+03:00
Do you know how to remove the yyyy and get the actual year?
And do you know how to remove the GMT + 3 to a fixed hour?
This comment was minimized by the moderator on the site
After struggling for 30 minutes with this thing and getting results like "14/05/yyyy hh:12:02", I finally cracked the code. Instead of =concatenate try using basic =A2+B2...
This comment was minimized by the moderator on the site
Hello KA,Sorry to hear that. If you don't mind, could you please show us more details on this matter? A screenshot is the best. We will try our best to help you?Sincerely,Mandy
This comment was minimized by the moderator on the site
Thank you for solving a problem that I have been wrestling with for the longest time! None of the "help" on CONCATENATE worked for me, but your formula above worked instantly. Fabulous!
This comment was minimized by the moderator on the site
It doesn't work. I do not understand the message below. I don't need it explained to me. I just need a formula that works please. Thank you.
"There's a problem with this formula.
Not trying to type a formula?
When the first character is an equal(=) or minus (-) sign, Excel thinks it's a formula.
you type: =1=1, cell shows : 2
To get around this, type an apostrphe (') firts:
you type: '=1=1, cell shows: =1+1"
I have replaced the rows and cells numbers and letters and have done it several times.