none
Add Seconds to DateTime value RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    1
    Sign in to vote

    My data source has some columns I want to add together.

    StartDate, which looks like 12/26/2014 4:13:40 PM
    and
    QueueTime, which is a whole number integer like 45088 (number of seconds)

    I want to add these together (the correct result would be 12/27/2014 4:45 AM).

    Can you let me know how to add these?  I didn't see any formulas to use for it in the Power Query forum index, but I also tried this with failure:

    =[StartDate] + ( [QueueTime]/86400 )

    This returned an error.

    Shawn Keene

    Friday, February 27, 2015 7:53 PM

Answers

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    [StartDate] + #duration(0, 0, 0, [QueueTime])
    Friday, February 27, 2015 10:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks a ton! Didn't know you could do that with the duration type.

    Shawn Keene

    Friday, February 27, 2015 10:56 PM