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
  • SpartaBI's avatar
    SpartaBI
    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

  • SpartaBI's avatar
    SpartaBI
    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

     





          

    Showcase Report – Contoso By SpartaBI

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

       





            

      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.