Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
How can I calculate the hours between two start / end times? The below formula does not calculate the hours correcly
Engage Hours per day = ([Start]-[End])
Solved! Go to Solution.
Hi @HenryJS ,
You could use Time.Hour() in query editor.
if [Start]>[End] then
24-Time.Hour([Start])+Time.Hour([End])
else Time.Hour([End])-Time.Hour([Start])
Here is the result.
Hi @HenryJS ,
Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |