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

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
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