Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to show hour difference with decimals

Hello, I have a table in which I calculated the hour difference with the following syntax: Duration.Hours(Hour #1 - Hour #2). I get the results correctly for the integer but I can't add the decimals. I've tried to change the data type in the transform section as well as add more decimals in the Data Tools tab. All without success.

 

E.g. Hour # 1: 12:00 PM, Hour #2: 12>55 PM, result = 0.00

Need Help

1 Reply

  • adudani's avatar
    adudani
    Icon for Memorable Member rankMemorable Member
    3 years ago

    hi Anonymous ,

     

    create a blank query and copy and paste the code below:

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTI0sjIwgNCmpiBmbCwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [task = _t, hour1 = _t, hour2 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"task", Int64.Type}, {"hour1", type time}, {"hour2", type time}}),
    #"Inserted Time Subtraction" = Table.AddColumn(#"Changed Type", "Subtraction", each [hour1] - [hour2], type duration)
in
    #"Inserted Time Subtraction"

     

    is this the desired output?

    if hour 1> hour 2, would you prefer returning a 0 instead of a negative value?