Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
How do I calculate the difference between two time columns?
Both columns are in HH:MM:SS and I would like the difference column to be the same.
thanks,
Solved! Go to Solution.
Hi @HenryJS,
Perhaps you can try to convert your time value to total second(numeric) then you can simply use math operator to calculate on converted values.
For duration and time value transform, you can take a look at the following blog:
Regards,
Xiaoxin Sheng
Hi @HenryJS,
Perhaps you can try to convert your time value to total second(numeric) then you can simply use math operator to calculate on converted values.
For duration and time value transform, you can take a look at the following blog:
Regards,
Xiaoxin Sheng
@HenryJS , if data type is time
Time diff = [time1] -[time2] //diff in time
diff = datediff([time1] ,[time2],hour) // hour ,min or sec etc
Hi @HenryJS
Assuming FF Hours 2 is your end time and Engage Hours per day 2 is your start time, try this
=Table1[FF Hours 2]-Table1[Engage Hours per day 2]
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi @HenryJS
In Power Query create a new Custom Column and subtract one from the other
#"Added Custom" = Table.AddColumn(#"Changed Type", "Difference", each [End]-[Start])
Phil
Proud to be a Super User!
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |