Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

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

Super User
Super User

hi @casr133 ,


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

    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)
    #"Inserted Time Subtraction"


is this the desired output?

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


Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a Kudos 🙂
Kind Regards,

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors