Forum Discussion

messyjesse_'s avatar
messyjesse_
Frequent Visitor
8 years ago
Solved

Converting true time value into duration in seconds

Hello, I have searched for a topic closely resembling the problem I'm encountering but haven't had much luck.   Background: I'm connecting to a folder of Excel workbooks and combining them. A new f...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi messyjesse_,

     

    The Query Editor just detects the type of the columns. You can change the display format in the Data pane.

    Converting_true_time_value_into_duration_in_seconds

     

    Best Regards,

    Dale

GregPBI's avatar
GregPBI
Frequent Visitor
3 years ago

I had that issue and I fixed it by adding a new columns like this :

 

duration = HOUR([Workflow_time])*3600 + MINUTE([Workflow_time])*60 + SECOND([Workflow_time])