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 ca...
Need Help
Shayz2402's avatar
Shayz2402
Frequent Visitor
4 years ago

Request everyone to please Help me.

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.

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

      Shayz2402 MY PLEASURE!! 🙂