Results 1 to 3 of 3

Merging date AND time collumns into one timeline

Threaded View

  1. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Merging date AND time collumns into one timeline

    Have you thought of using Pivot table?
    Look at the attached file.
    There is a macro created by recording the necessary changes that will copy all data in the proper format to use a pivot table or graph.
    I copied your actual data in a second sheet to keep a copy of original data so you can try it.
    Attached Files Attached Files
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

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