+ Reply to Thread
Results 1 to 3 of 3

Time series matching date and time with values

  1. 08-28-2024, 08:25 AM #1
    mixers99
    mixers99 is offline
    Registered User
    Join Date
    03-20-2023
    Location
    Croatia
    MS-Off Ver
    Software Microsoft Office 2021 Home & Student
    Posts
    16

    Talking Time series matching date and time with values

    Hi all!

    I have a sheet with time series values, however, they are mismached because some date and times are missing for some values. How do I arrange them in a new sheet where all dates and times match in their rows?

    All help is much appreciated!New Microsoft Excel Worksheet (7).xlsx
    Reply With QuoteRegister To Reply
  2. 08-28-2024, 09:31 AM #2
    macropod
    macropod is offline
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,778

    Re: Time series matching date and time with values

    One solution attached, with all possible data rows to 31/12/2024 populated on Sheet2.
    Attached Files Attached Files
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]
    Reply With QuoteRegister To Reply
  3. 08-28-2024, 11:01 AM #3
    mixers99
    mixers99 is offline
    Registered User
    Join Date
    03-20-2023
    Location
    Croatia
    MS-Off Ver
    Software Microsoft Office 2021 Home & Student
    Posts
    16

    Re: Time series matching date and time with values

    Thank you so much! This works perfectly!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Date challenge - transform effective date range to day time series
    By Notsoeasy in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-20-2024, 06:48 AM
  2. Convert date/time text to date/time values
    By Panos1221 in forum Excel General
    Replies: 11
    Last Post: 11-24-2020, 04:31 PM
  3. [SOLVED] Time difference between two date/time values which are in the format DD-MM-YYY HH:MM
    By snkhan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2020, 10:31 AM
  4. Calculating total time between start date\time and End date\time excluding non business
    By jonashlock in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-15-2015, 07:32 PM
  5. I have a long time series (date and time) that has values missing. How can I insert them?
    By mildertgirl in forum Excel General
    Replies: 2
    Last Post: 04-10-2013, 11:17 AM
  6. Using RIGHT Function to extract time values in date / time field
    By endora75 in forum Excel General
    Replies: 4
    Last Post: 03-23-2010, 12:44 PM
  7. Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 12:24 PM

Tags for this Thread

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