对于小时组件，持续时间文字的最大值只能为23。否则，您必须自己创建该值。
您可以添加自定义列：

您需要更改公式中的列名以适合您的实际数据

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQ2tDIytTI2VorViVYyMbQyMLYyNAFzDI0srEzMrQwMlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Time = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Time", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Duration", each 
      let 
        Split = List.Reverse(List.Transform(Text.Split([Time],":"),each Number.From(_))),
        sec = Split{0},
        min = Split{1},
        hrs = Number.Mod(Split{2},24),
        dys = if List.Count(Split)=4 
                then Split{3} 
                else Number.IntegerDivide(Split{2},24)
      in  
        #duration(dys,hrs,min,sec), type duration)
in
    #"Added Custom"

或者你可以在不添加额外列的情况下就地更改它：

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQ2tDIytTI2VorViVYyMbQyMLYyNAFzDI0srEzMrQwMlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Time = _t]),
    #"Transform to Duration" = Table.TransformColumns(Source, {"Time", (c)=> 
      let 
        Split = List.Reverse(List.Transform(Text.Split(c,":"),each Number.From(_))),
        sec = Split{0},
        min = Split{1},
        hrs = Number.Mod(Split{2},24),
        dys = if List.Count(Split)=4 
                then Split{3} 
                else Number.IntegerDivide(Split{2},24)
      in  
        #duration(dys,hrs,min,sec)}),
    #"Set Data Type" = Table.TransformColumnTypes(#"Transform to Duration", {"Time", type duration})

in
    #"Set Data Type"

结果

我找到了解决办法。
添加新列并更新该自定义列的以下M代码：

Number.FromText ( 
    Text.BeforeDelimiter([duration],":") 
    ) * 60 * 60
+ Number.FromText ( 
    Text.BetweenDelimiters([duration], ":", ":" ) 
    ) * 60
+ Number.FromText ( 
    Text.AfterDelimiter([duration], ":", {0, RelativePosition.FromEnd})  
    )

欲了解更多详情，请查看此链接：https://community.powerbi.com/t5/Power-Query/Convert-to-Time-Format-in-the-Power-Query-Editor-in-Power-BI/m-p/3178431#M102141
如果我说错了，请纠正我，谢谢！