+ Reply to Thread
Results 1 to 2 of 2

DateAdd problem

  1. #1
    Registered User
    Join Date
    09-13-2007
    Posts
    5

    DateAdd problem

    Hi all
    In column D I have a list of values (seconds) which I want to add to an epoch time of 01/01/1900 00:00:00, i have tried inserting the epoch date into a cell then adding a column next to D and using the following to calculate the date/time and copy it down the column for all the values in D.

    Please Login or Register  to view this content.
    This appears to work ok but when I cross check the results all the dates/time values in E are 2 days out.
    I think I should be converting D into minutes then using something like DateAdd("m", value of D, "01/01/1900 00:00:00")

    But not sure this would work or how to implement it.

    Any advice would be greatly appreciated.

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: DateAdd problem

    Please Login or Register  to view this content.



+ 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