How to convert DATE/TIME Column to duration?

[ggarciadynamik4]

Hello Everyone, 

I linked an external database to access and then linked from access to PowerBI.
I am trying to create a dashboard to extract worked hours, but when doing the link described above, the worked hours came as DATE/TIME, not duration, so PowerBI does not sum the hours correctly, I need to convert DATE/TIME to duration but didn't find any solution to make this. 

I already tried to do as bellow 
EDIT QUERY / Transform Collum / Transform Time only  = The time came i.e. 5:00:00. 
Also tried to convert as Duration, but PowerBI just give me a message of error, not allowing to convert it. 

Can someone help me?

[d_gosbell · Accepted solution]

You cannot automatically convert a Time column to a duration since a Time is a single point in time so it has no duration. But in your case it sounds like something like 05:00 should be a duration of 5 hours. So one way to do this is calculate the duration from midnight to the specified time. You can do this by subtracting a time of "00:00" from your current time column (subtracting one time from another returns a duration)

If you click on "Add Column" in the ribbon then choose the "Custom Column" optoin and enter a formula like the following it will return a duration.

[YourTimeColumn] - Time.FromText("00:00:00")

[searl]

worked perfectly - thank you

[Greg_Deckler]

@ggarciadynamik4 Chelsie Eiden's Duration - Microsoft Power BI Community