Combine date and time cells in excel

How to combine date and time cells in excel

2
10731
combine date and time cells in excel

You can easily combine date and time of two different cells in excel, all you have to do is enter the following into the formula bar:

=TEXT(date_cell,”dd/mm/yyyy “)&TEXT(time_cell,”hh:mm:ss”)

Example

Below is a worked example for how to combine a date and time cell in excel:

How to combine date and time cells in excel

=TEXT(A2,“dd/mm/yyyy “)&TEXT(B2,”hh:mm:ss”)

Tools you'll need

2 COMMENTS

  1. I like your pߋst. I check out your blog fairly regularly, and you’re continuousⅼy coming up
    with some great staff. I shaгeⅾ this blog pօst on my Tumblr, and my followers loved іt.
    To the next. Ꮯheers.

  2. Youг style is quite unusual compared to otһer folks I have checked
    info from. Thank you for sharing when you’ve ɡot thе time, suppose I will
    just save this post.

LEAVE A REPLY

Please enter your comment!
Please enter your name here