Results 1 to 6 of 6

Thread: Converting 1000000 seconds in power query does not give the right days

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Lisa77's Avatar
    Join Date
    Aug 2021
    Posts
    3
    Articles
    0
    Excel Version
    O365

    Converting 1000000 seconds in power query does not give the right days

    Hi please see attachment, I need to convert seconds to dd:hh:mm:ss. PQ does not calculate the correct days when it reaches a million seconds it seems. Any help would be appreciated. Thank you.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •