Duration is reflecting in Time Format AM/PM

[Shayz2402]

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.

[SpartaBI · Accepted solution]

@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]

Request everyone to please Help me.

[SpartaBI · Accepted solution]

@ 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]

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]

@Shayz2402 MY PLEASURE!! 🙂

[SpartaBI · Accepted solution]

@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]

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