+ Reply to Thread
Results 1 to 2 of 2

Convert two different sets of dates and times to one shared vector

Hybrid View

  1. #1
    Registered User
    Join Date
    02-29-2016
    Location
    Boston MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Convert two different sets of dates and times to one shared vector

    Say I have two different sets of dates and times. Is there a way to convert these to one same time vector with both initial date and time start at t = 0?:

    01/05/10 15:00 EST <---- t=0
    01/05/10 15:15 EST
    01/05/10 15:30 EST
    01/05/10 15:45 EST
    01/05/10 16:00 EST
    01/05/10 17:00 EST

    and

    05/28/10 13:00 EDT <---- t=0
    05/28/10 13:15 EDT
    05/28/10 13:30 EDT
    05/28/10 13:45 EDT
    05/28/10 14:00 EDT
    05/28/10 14:30 EDT
    05/28/10 15:00 EDT

  2. #2
    Registered User
    Join Date
    01-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    18

    Re: Convert two different sets of dates and times to one shared vector

    It looks like each value is increasing in increments of 15 minutes. Hence, the increment is described by 15/(60*24) = 15/1440
    Try this: If you already have t0, then, t1 = t0 + (15/1440); t2= t1 + (15/1440); etc.

+ 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. Convert string dates and times to different format
    By excel12121 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-22-2014, 02:39 PM
  2. Replies: 4
    Last Post: 08-11-2014, 07:08 PM
  3. Replies: 1
    Last Post: 04-01-2014, 02:53 AM
  4. Convert Frequency Table to Vector
    By trench3368 in forum Excel General
    Replies: 3
    Last Post: 07-04-2013, 12:20 PM
  5. Replies: 6
    Last Post: 05-17-2010, 02:25 AM
  6. find days and hours between 2 sets of dates and times
    By The Auditor in forum Excel General
    Replies: 1
    Last Post: 02-03-2006, 04:10 PM
  7. how can I multiply a 45-vector times a 45*45 matrix?
    By jortorzor in forum Excel General
    Replies: 2
    Last Post: 03-24-2005, 11:06 AM

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