Note: The other languages of the website are Google-translated. Back to English
Logáil isteach  \/ 
x
or
x
Cláraigh  \/ 
x

or

Conas dáta agus am a chur le chéile i gcill amháin in Excel?

doc an dáta dáta a chomhcheangal i gceann 1
Tá dhá cholún i mbileog oibre, is é ceann an dáta, is é an ceann eile am, mar a thaispeántar thíos, an bhfuil aon bhealach ann an dá cholún seo a chur le chéile go tapa i gceann amháin, agus an fhormáid ama a choinneáil? Anois, tugaim isteach dhá bhealach in Excel chun colún dáta agus colún ama a chur le chéile i gceann amháin agus an fhormáid ama a choinneáil.
Comhcheangail dáta agus am leis an bhfoirmle in Excel
Comhcheangail dáta agus am le Kutools le haghaidh Excel smaoineamh maith3      imirt

mboilgeog cheart gorm saighead Comhcheangail dáta agus am leis an bhfoirmle in Excel

Tá foirmle an-simplí ann a chabhróidh go tapa leat colún dáta agus colún ama a chur le chéile i gceann amháin.

Clóscríobh an fhoirmle seo = TEXT (A2, "m / dd / yy") & TEXT (B2, "hh: mm: ss") (Léiríonn A2 na chéad sonraí i gcolún dáta, seasann B2 na chéad sonraí i gcolún ama, is féidir leat iad a athrú de réir mar is gá duit) i gcill bhán, agus brúigh Iontráil eochair, ansin tarraing an láimhseáil líonta chun an raon a theastaíonn uait an fhoirmle seo a úsáid a líonadh. Féach an pictiúr:
doc an dáta dáta a chomhcheangal i gceann 2

Leid: Is féidir leat an fhoirmle seo a úsáid freisin = A2 + B2 agus ansin na cealla toraidh a fhormáidiú mar fhormáidiú dáta agus ama.


mboilgeog cheart gorm saighead Comhcheangail dáta agus am le Kutools le haghaidh Excel

Leis an bhfoirmle thuas, b’fhéidir go gcaillfidh tú toradh na foirmle nuair a chuirfidh tú an bhileog oibre in eagar. Anois tugaim a Comhcheangail Sraitheanna, Colúin nó Cealla gan Sonraí a chailleadh fóntais de Kutools le haghaidh Excel duit na sonraí agus na cealla ama a chomhcheangal go díreach i gceann amháin. Más maith leat uirlis nua áisiúil a thriail, is féidir leat íoslódáil triail a bhaint as.

Kutools le haghaidh Excel, le níos mó ná 300 feidhmeanna úsáideacha, déanann sé do phoist níos éasca. 

Tar éis suiteáil saor in aisce Kutools for Excel, déan mar atá thíos le do thoil:

1. Roghnaigh na dátaí agus na hamanna is mian leat a chur le chéile, agus cliceáil Kutools > Cumaisc & ScoiltChomhcheangail Sraitheanna, Colúin nó Cealla gan Sonraí a chailleadh. Féach an pictiúr:
doc an dáta dáta a chomhcheangal i gceann 3

2. Sa dialóg popping, sonraigh an socrú:

doc an dáta dáta a chomhcheangal i gceann 4
(1) Seiceáil Comhcheangail colúin faoi Cealla roghnaithe a chur le chéile de réir na roghanna seo a leanas (Má tá do dhátaí agus amanna curtha ina dhá shraith, is féidir leat seiceáil Comhcheangail sraitheanna),

(2) Roghnaigh deighilteoir chun na sonraí comhcheangailte a scaradh, is féidir leat a roghnú Spás, Ní dhéanfaidh aon ní nó clóscríobh an deighilteoir atá uait sa bhosca téacs,

(3) Cuir an toradh ar: Cill chlé or Cill cheart,

(4) Sonraigh na roghanna faoi na cealla comhcheangailte, Coinnigh ábhar na gcealla comhcheangailte, Scrios ábhar na gcealla comhcheangailte, Cumaisc na cealla comhcheangailte.

3. cliceáil Ok. Agus ansin ní mór duit na cealla a fhormáidiú mar fhormáid dáta agus ama.

Coinnigh ábhar na gcealla comhcheangailte
Scrios ábhar na gcealla comhcheangailte
Cumaisc na cealla comhcheangailte
doc an dáta dáta a chomhcheangal i gceann 5
doc an dáta dáta a chomhcheangal i gceann 6
doc an dáta dáta a chomhcheangal i gceann 7

nótaí:
Tacaíonn an oibríocht seo Undo.
Ba ghá na cealla toraidh a fhormáidiú mar mm / dd / bbbb hh: mm: ss formáidiú i Cealla Formáid dialóg.

Leid. Más mian leat triail saor in aisce a fháil ar an Comhcheangail Cealla feidhm, téigh chuig Kutools le haghaidh Excel saor in aisce ar dtús, agus ansin téigh chun an oibríocht a chur i bhfeidhm de réir na gcéimeanna thuas.

mboilgeog cheart gorm saighead Comhcheangail Dáta agus Am in Aon Chill


Comhcheangail go héasca bileoga iolracha / Leabhar Oibre in aon bhileog amháin nó Leabhar Oibre

D’fhéadfadh go mbeadh bileoga nó leabhair oibre le chéile in aon bhileog amháin nó leabhar oibre in Excel, ach leis an Chomhcheangail feidhm i Kutools le haghaidh Excel, is féidir leat an iliomad bileoga / leabhar oibre a chumasc i mbileog amháin nó i leabhar oibre, freisin, is féidir leat na bileoga a chomhdhlúthú i gceann amháin le cúpla cad a tharlaíonn.  Cliceáil le haghaidh trialach saor in aisce 30 lá le feiceáil go hiomlán!
bileoga a chur le chéile
 
Kutools for Excel: le níos mó ná 300 breiseán áisiúil Excel, saor in aisce le triail gan aon teorannú i 30 lá.

Na hUirlisí Táirgiúlachta Oifige is Fearr

Réitíonn Kutools for Excel an chuid is mó de do chuid Fadhbanna, agus Méadaíonn sé do Tháirgiúlacht 80%

  • Athúsáid: Cuir isteach go tapa foirmlí casta, cairteacha agus aon rud a d'úsáid tú roimhe seo; Cealla a Chriptiú le pasfhocal; Cruthaigh Liosta Ríomhphoist agus seol ríomhphoist ...
  • Barra Foirmle Super (cuir línte iolracha téacs agus foirmle in eagar go héasca); Leagan Amach Léitheoireachta (líon mór cealla a léamh agus a chur in eagar go héasca); Greamaigh go dtí an Raon Scagtha...
  • Cumaisc Cealla / Sraitheanna / Colúin gan Sonraí a chailleadh; Ábhar Cealla Scoilt; Comhcheangail Sraitheanna / Colúin Dúblacha... Cill Dúblach a Chosc; Déan comparáid idir Ranganna...
  • Roghnaigh Dúblach nó Uathúil Sraitheanna; Roghnaigh Blank Rows (tá na cealla uile folamh); Aimsigh Super agus Fuzzy Aimsigh i go leor Leabhar Oibre; Roghnaigh go randamach ...
  • Cóip Díreach Cealla Il gan tagairt fhoirmle a athrú; Tagairtí Cruthaigh Auto chuig Bileoga Il; Cuir Urchair isteach, Boscaí Seiceála agus go leor eile ...
  • Sliocht Téacs, Cuir Téacs leis, Bain de réir Poist, Bain Spás; Subtotals Paging a chruthú agus a phriontáil; Tiontaigh Idir Ábhar Cealla agus Tráchtanna...
  • Scagaire Super (scéimeanna scagaire a shábháil agus a chur i bhfeidhm ar bhileoga eile); Ard-Sórtáil de réir míosa / seachtaine / lae, minicíocht agus níos mó; Scagaire Speisialta le cló trom, iodálach ...
  • Comhcheangail Leabhair Oibre agus Bileoga Oibre; Cumaisc Táblaí bunaithe ar eochaircholúin; Roinn Sonraí i Ilbhileoga; Baisc Tiontaigh xls, xlsx agus PDF...
  • Níos mó ná 300 gné chumhachtach. Tacaíochtaí Office / Excel 2007-2019 agus 365. Tacaíonn sé le gach teanga. Imscaradh éasca i d’fhiontar nó d’eagraíocht. Gnéithe iomlána triail saor in aisce 30 lá. Ráthaíocht ar ais airgid 60 lá.
cluaisín kte 201905

Tugann Tab Oifige comhéadan Tabbed chuig Office, agus Déan Do Obair i bhfad Níos Éasca

  • Cumasaigh eagarthóireacht agus léamh tabbed i Word, Excel, PowerPoint, Foilsitheoir, Rochtain, Visio agus Tionscadal.
  • Oscail agus cruthaigh cáipéisí iolracha i gcluaisíní nua den fhuinneog chéanna, seachas i bhfuinneoga nua.
  • Méadaíonn do tháirgiúlacht 50%, agus laghdaíonn sé na céadta cad a tharlaíonn nuair luch duit gach lá!
bun officetab
Say something here...
symbols left.
You are guest
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
  • To post as a guest, your comment is unpublished.
    alejandro · 1 months ago
    Para todos aquellos que no les funciono, la forma correcta sería esta:

    =TEXTO(D9,"dd/m/aaaa")+TEXTO(E9,"hh:mm:ss")

    recuerden solo cambiar sus celdas y columnas

    • To post as a guest, your comment is unpublished.
      Sunny · 1 months ago
      Hi, alejandro, thanks for your message. The formula in the articel works at English version but not work at Spanish version. Thanks again for you to privide a formula for Spanish readers.
  • To post as a guest, your comment is unpublished.
    igsaan mohamed · 6 months ago
    Hi All
    Why do i get #Value if i try and combine Date and Time 
    Thanks

    • To post as a guest, your comment is unpublished.
      Sunny · 2 months ago
      Hi, maybe your data is in a format the formula not support. In a new sheet, enter the date and time manully and try the formula again.
  • To post as a guest, your comment is unpublished.
    Gaby · 1 years ago
    hi!
    my date it's fine that's normal but the hours it's like this 54054 it's mean 05:40:54, and i need combine whit my date

    can you help me please?

    • To post as a guest, your comment is unpublished.
      Sunny · 1 years ago
      Hi, Gaby, pnly the time string must be in 6-digit such like 054054, my formula=TEXT(F1,"m/dd/yy ")&TEXT(TIME(LEFT(G1,2),MID(G1,3,2),RIGHT(G1,2)),"hh:mm:ss") can help you. See screenshot:
  • To post as a guest, your comment is unpublished.
    dEEPAK · 2 years ago
    i WANT DATE OF YESTERDAY AND TIME DIFFERENCE BETWEEN TWO COUNTY TOGETHER..HOW CN I GET THAT?
  • To post as a guest, your comment is unpublished.
    makhphi@gmail.com · 2 years ago
    The article saved my job because I finished the report I work on in 5minutes but I need assistance of a formula that will return a difference between two cells with combined date and time. Example 18/2/19 08:35 and 21/2/19 08:32.
  • To post as a guest, your comment is unpublished.
    Robin · 2 years ago
    how can you combine a column with a date and another column with a code?
    • To post as a guest, your comment is unpublished.
      Sunny · 2 years ago
      Sorry, Robin, your problem is not clear, could you describe it with more details or upload some screenshots? I do not know what is code?
  • To post as a guest, your comment is unpublished.
    Manjunath · 3 years ago
    Col A= 2-Jan-19 Col B= 3:07 PM and formal is TEXT(B4,"dd/mmm/yyyy")&TEXT(C4,"hh:mm"), and output is 01/02/1915:07... if i need the Space in between Date and Time
    • To post as a guest, your comment is unpublished.
      Parswanatha · 3 years ago
      Use like this =TEXT(H2,"m.dd.yy")& " "&TEXT(I2,"hh:mm:ss")
  • To post as a guest, your comment is unpublished.
    Amjad Javed · 3 years ago
    (Column B) (Column C) (Column D)
    (KASHIF GULZAR SHAIKH) (10-05-2018 10:36) (24381530028971)

    after Marge Formula =B2&" "&C2&" "&D2
    KASHIF GULZAR SHAIKH 43230.4419097222 24381530028971
  • To post as a guest, your comment is unpublished.
    Amjad Javed · 3 years ago
    B C D
    KASHIF GULZAR SHAIKH 10-05-2018 10:36 24381530028971

    after merge
    KASHIF GULZAR SHAIKH 43230.4419097222 24381530028971
    • To post as a guest, your comment is unpublished.
      Raghu · 2 years ago
      use this
      =TEXT(10-05-2018,"dd:mm:yyyy")&" "&TEXT(10:36,"hh:mm")&" "&TEXT(24381530028971,"00000000000000")
  • To post as a guest, your comment is unpublished.
    Jenny · 4 years ago
    This is so great, thank you!
  • To post as a guest, your comment is unpublished.
    Hocine · 4 years ago
    Thank you, you saved my day !
  • To post as a guest, your comment is unpublished.
    Praveen · 5 years ago
    your article helped me a lot. Really appreciate your info. Thanks
  • To post as a guest, your comment is unpublished.
    Namso · 5 years ago
    This was absolutely correct. I was in a state of panic and in one click, everything was sorted. I copied the formular and it worked like a charm. Thank you very much :D
  • To post as a guest, your comment is unpublished.
    Graham Dragon · 5 years ago
    Why make it so complicated? Why not simply say "=A2+B2" and format that column to display date and time? As long as you have only put the date in column A, it will assume the time is 00:00, and the addition will therefore be the exact date and time of the two columns.
    • To post as a guest, your comment is unpublished.
      sunflower · 5 years ago
      [quote name="Graham Dragon"]Why make it so complicated? Why not simply say "=A2+B2" and format that column to display date and time? As long as you have only put the date in column A, it will assume the time is 00:00, and the addition will therefore be the exact date and time of the two columns.[/quote]
      Appreciate your answer. In fact, in solution 1, there is a tip to remind everyone can use the formula =A2+B2 to solve the job, too. Thank you for your reading again.
    • To post as a guest, your comment is unpublished.
      IanB · 5 years ago
      Wow, that makes such a difference, and with such simplicity.
    • To post as a guest, your comment is unpublished.
      Blee · 5 years ago
      Wow.....thanks Graham. Can't believe how much of a headache this caused me to do all because I didn't start with the simplest solution first. Sometimes less is more.
  • To post as a guest, your comment is unpublished.
    Colin · 7 years ago
    Combine the date and time with a plus sign + in a third column. Custom formatting can look after preserving the time format.