+ Reply to Thread
Results 1 to 3 of 3

Putting Together Date and Time into one column from two columns from another dynamic sheet

  1. #1
    Registered User
    Join Date
    08-06-2012
    Location
    Albuquerque, New Mexico
    MS-Off Ver
    Excel 2010
    Posts
    12

    Putting Together Date and Time into one column from two columns from another dynamic sheet

    Hopefully this code will kind of make sense to you guys in explaining what I am trying to do.... Please see attached excel to see example. Sheet1 is the original data sheet and the data will be dynamic. I am trying to make it look like sheet2....
    My Brain is Fried trying various ways to solve this. Looking for some help!

    ExampleDateTime.xlsm

    Please Login or Register  to view this content.
    Last edited by goradiar; 10-23-2012 at 01:39 AM. Reason: Added code tags for new user. Please do so next time...Thanks.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Putting Together Date and Time into one column from two columns from another dynamic s

    Hi, goradiar,

    maybe you are looking for something like (output on Sheet3)
    Please Login or Register  to view this content.
    Or do you want to insert a formula in Sheet2 like in the sample file?

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    08-06-2012
    Location
    Albuquerque, New Mexico
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Putting Together Date and Time into one column from two columns from another dynamic s

    I figured it out but in a very crude way. I would like to try your code though since it is much nicer looking. Just by looking at your code I can really understand it.
    I will let you know if I have any problems with it.

    To the question about the formula inserting into sheet2, it is not neccessary.

    Thank you for your help and reply!

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1