Add Seconds to DateTime value RRS feed

  • Question

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

    StartDate, which looks like 12/26/2014 4:13:40 PM
    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


All replies

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

    Shawn Keene

    Friday, February 27, 2015 10:56 PM