Results 1 to 5 of 5

How to concatenate date and time in one cell?

Threaded View

  1. #1
    Forum Contributor unley's Avatar
    Join Date
    11-27-2008
    Location
    South Australia
    MS-Off Ver
    MS Office 2007
    Posts
    253

    How to concatenate date and time in one cell?

    Hi all

    I have done some search on google and here in the forum but with no luck.

    After the data from our data base was sent to Excel, the start date in A2 is in date format and the start time in B2 is in text format. What formula could I use to concatenate both date and time in one cell with a space in between

    In cell A2, I have 7/06/2016.
    In cell B2, I have 09:06:00

    Would like C2 to become 7/06/2016 9:06

    I also have the finish date in cell E2 and finish time in cell F2 in the data Excel file sent from our database and I want to see the difference in how long the person took to finish off the job.

    Hope I have made it clear

    Thanks guys
    Attached Files Attached Files
    Last edited by unley; 06-07-2016 at 11:20 PM.
    I'm using MS Office 2013

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Can't concatenate time and date cells
    By loba333 in forum Excel General
    Replies: 4
    Last Post: 10-07-2014, 11:28 PM
  2. concatenate date and time
    By jej in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-06-2014, 09:09 AM
  3. Concatenate Date+Time+Am or PM then sum hours
    By bjsmithinc in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-16-2013, 09:17 PM
  4. concatenate a field with date and time
    By Foxcan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-05-2009, 03:30 PM
  5. merge date/time value , concatenate ?
    By okl in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2008, 07:15 AM
  6. Concatenate Date and Time
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-12-2008, 10:14 AM
  7. Date and Time Concatenate Help
    By Mr Gow in forum Excel General
    Replies: 3
    Last Post: 01-22-2007, 10:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1