Results 1 to 3 of 3

Concatenate Date and Time

Threaded View

  1. 05-12-2008, 09:15 AM #1
    Jim15
    Jim15 is offline
    Forum Contributor
    Join Date
    08-15-2005
    Location
    Oklahoma
    MS-Off Ver
    2010, 2013
    Posts
    112

    Concatenate Date and Time

    Attached is an Excel spreadsheet with Date and Time in 1st and 2nd columns, respectively. The 3rd column is how I want the data to look for plotting. How do I concatenate columns 1 and 2 to arrive at 3? When I concatenate, I get a number for the data instead of date.

    Thanks,

    Jim Williams
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1