+ Reply to Thread
Results 1 to 3 of 3

Hi, I have hourly time series data and i need to convert it to 15 min time slots

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    delhi
    MS-Off Ver
    MS office 10 & office 13
    Posts
    2

    Hi, I have hourly time series data and i need to convert it to 15 min time slots

    I have hourly time series data and i need to convert it to 15 min time slot, how it is possible ?
    By n degree polynomial or any other method plz explain.

    data is as follows:

    23:30 3.45
    00:30 5.65
    01:30 6.34
    02:30 9.32
    03:30 7.32
    . .
    . .
    . .
    . .
    . .
    22:30 1.23
    23:30 4.32


    and resultant required is as follows:
    00:00 ----
    00:15 ----
    00:30 5.65
    00:45 ----
    01:00 ----
    01:15 ----
    01:30 6.34
    .
    .
    .
    .
    .
    23:30
    23:45

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Hi, I have hourly time series data and i need to convert it to 15 min time slots

    Make a table with 0:15 span.

    Afther that use VLookup to fnd the data in the Original data.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    07-15-2014
    Location
    delhi
    MS-Off Ver
    MS office 10 & office 13
    Posts
    2

    Re: Hi, I have hourly time series data and i need to convert it to 15 min time slots

    i don't have data for those slots i need to interpolate (linear interpolation) or Curve fitting.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. booking time slots
    By peter renton in forum Excel General
    Replies: 7
    Last Post: 10-07-2019, 05:49 AM
  2. [SOLVED] Categorizing the Time into Time Slots
    By zaveed in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2013, 01:27 PM
  3. [SOLVED] calculating a time range into predefined time slots
    By DamianWarS in forum Excel General
    Replies: 2
    Last Post: 06-19-2012, 07:26 AM
  4. Replies: 0
    Last Post: 04-23-2012, 10:06 AM
  5. Calculating hourly averages from 15 minute time-series data
    By randinator in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2012, 12:18 PM

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