Forum Discussion

Shayz2402's avatar
Shayz2402
Frequent Visitor
4 years ago
Solved

Duration is reflecting in Time Format AM/PM

Hi,

 

I have a Data on Google sheet which is in Duration Format and when I link this sheet with Power Bi Data Source it is reflecting in Time Format AM/PM

 

I would really appreciate if anyone can please me show the same duration as it is in my data sheet.

 

PFB Screenshot for your refrenec.

 

 

Thanks.

 

Need Help

6 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Shayz2402 you can PM me and we could do a quick zoom to look together if you want. Hard to see from the sceenshots

    • Shayz2402's avatar
      Shayz2402
      Frequent Visitor
      4 years ago

      Hi SpartaBI Thanks for your reply. Can you please confirm your availablity for today to connect on Zoom.

    • SpartaBI's avatar
      SpartaBI
      Icon for Community Champion rankCommunity Champion
      4 years ago

      @ this is the code:

       

      Five 9 Total = 
VAR _value = SUM(Sheet7[Five 9 Login TIme])
VAR _hours = DATEDIFF(DATE(1899,12,30),_value,DAY) * 24 + HOUR(_value)
VAR _minutes = MINUTE(_value)
VAR _seconds = SECOND(_value)
RETURN
    _hours & ":" & _minutes & ":" & _seconds

       


      In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.


      SpartaBI Logo

      Visit SpartaBI website   Visit SpartaBI Linkdin   Visit SpartaBI Facebook

      Showcase Report – Contoso By SpartaBI

      • Shayz2402's avatar
        Shayz2402
        Frequent Visitor
        4 years ago

        Thanks a lots SpartaBI You are an very knowlagable and amazing Person. You safe my day and also it means a lot to me.

        Thanks a Lot and Much appreciated your help and support.
        Looking forward to work with you.