Convert Field of Time Type During Data Refresh

Hi ovetteabejuela，

If you mean that multiply the time field by 24 before loading data into Power BI, from my point of view, you would need to implement the process in  your source.

However, if you want to implement the multiplication for multiple time type field in Query Editor, to simplify the process,  you can create a parameter in Query Editor as shown in the first screenshot, change the type of your time field to Decimal number, then add a custom column as shown in the second screenshot.

The above steps generate bold part of the following code in Advanced Editor, you can add these codes (replace dur_scheduled with other field names) into Advanced Editor of different queries based on your needs.

let
    Source = Excel.Workbook(File.Contents("path\New Microsoft Excel Worksheet (3).xlsx"), null, true),
    Table2_Table = Source{[Item="Table2",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Table2_Table,{{"dur_scheduled", type time}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"dur_scheduled", type number}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each [dur_scheduled]*Para),
    #"Changed Type2" = Table.TransformColumnTypes(#"Added Custom",{{"Custom", type number}})
in
    #"Changed Type2"

Thanks,
Lydia Zhang