Hey everyone,So initally i had two time values, which was StartTime and EndTime and right now I got the duration between both as one column, but in the duration format. The problem is, I can't figure out how to make it as a decimal or whole number, so I could display it as a sum in histogram. The closest I got to this is take duration as total hours, however, I need precise time to be displayed in the histogram as a value. Any ideas?

Hello Anonymous check out this code let StartTime = #time(12,0,0), EndTime = #time(16,30,0), DurationDigital = Number.From(EndTime-StartTime)*24 in DurationDigital Copy paste this code to the advanced editor in a new blank query to see how the solution works.If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)Kudoes are nice tooHave funJimmy

It seems like its displaying 4,5, but i would need it to be 4:30(as a decimal number) if that makes sense.Thanks for your help.

Hello Anonymous 4:30 it's text format. Just convert the duration to text. Here the code let StartTime = #time(12,0,0), EndTime = #time(16,30,0), DurationDigital = Duration.ToText(EndTime-StartTime) in DurationDigital Copy paste this code to the advanced editor in a new blank query to see how the solution works.If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)Kudoes are nice tooHave funJimmy

Jimmy801 That is what I need, however I can't sum up text value to display it in histogram, any way I could sum up this text format to display it into values?

Converting time value to a decimal number so it could be displayed as a value

Forum Discussion

Related content

Convert time (hh:mm) to decimal

Can't convert text to decimal

Percentages displaying as decimals

Decimal Precision

Convert hh:mm to decimals