Tyger Guzman Profolio
  • About
  • Resume
    Tyger Guzman

    Tyger Guzman

    Data Analysis with Call Center Background

    • San Antonio, Tx
    • LinkedIn
    • GitHub
    • Email

    Pq int to hhmmss

    less than 1 minute read

    Int to HHMMSS
    Problem: 
        Pass an integer to a SQL Query in Excel Power Query. 

    Solution: 
        How to Calculate Duration by Interval (IE : 10/3 = 3 instead of 3.3333) to calculate seconds without decimals. 

      #"Added Custom" = Table.AddColumn(Source, "AWTMeasure", each if [CallsAnswered] = 0 then 0  else [AnswerWaitTimeSeconds]/[CallsAnswered]),
        #"Added Custom1" = Table.AddColumn(#"Added Custom", "Custom", each Text.From([AWTMeasure])),
        #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom1",),
        #"Added Custom2" = Table.AddColumn(#"Changed Type1", "Custom.1", each if [CallsAnswered] = 0 then "0"

    else if Text.PositionOf([Custom],".") > 0 then

    Text.Start([Custom],Text.PositionOf([Custom],".")) else


    [Custom]),
        #"Changed Type2" = Table.TransformColumnTypes(#"Added Custom2",),
        AWT = Table.AddColumn(#"Changed Type2", "AWT", each [Custom.1] / (60*60*24)),

    Categories: Excel

    Updated: September 27, 2018

    Share on

    Twitter Facebook Google+ LinkedIn
    Previous Next

    You may also enjoy

    Shpt overtimelist

    less than 1 minute read

    Overtime Sign-Up

    Shpt hidesidenav

    less than 1 minute read

    Hide SideNav

    Shpt downloadfile

    less than 1 minute read

    Download A File

    Shpt cssfile

    1 minute read

    CSS File

    • Follow:
    • Feed
    © 2018 Tyger Guzman. Powered by Jekyll & Minimal Mistakes.