+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : How do I Separate Date and Time and combine 2 cells

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    dubai uae
    MS-Off Ver
    Excel 2003
    Posts
    1

    How do I Separate Date and Time and combine 2 cells

    The attachment is extracted from a software called statex, we use it in a media company for us to see how many Advertisements appeared according to the scheduled time per program.

    I need an excel formula for below.

    1. I want to separate the date and time
    2. Combine the time (ex.19:10:36 & 19:19:55) per program (ex. full ticket - as the same time appeared in the same program)
    3. also combine SPT (ex. 3 of 9 - highlighted in yellow) per program (ex. full ticket - as the same time appeared in the same program)

    Would appreciate if you can help me create a formula for the above as i use to do this the whole day all the time manually.

    Thanks a lot.
    Attached Images Attached Images

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: How do I Separate Date and Time and combine 2 cells

    Hi,

    Please review the forum rules and upload a workbook not just a picture. You should also add the results that you expect to see, and a note as to how you arrived at the results. It's not obvious (to me at least) exactly what you mean.

    Regards
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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