Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
How can I convert decimal to duration format?
response time | target response time |
00:30:00 | 2,50 |
01:00:00 | 0,433 |
02:00:00 | 1,133 |
I want to convert the column "target response time" to the format of the column "response time".
Example: 2,50 must be converted to 02:30:00
Thank you.
Solved! Go to Solution.
@anlu20 Maybe:
Column = FORMAT(INT([Column1]),"00") & ":" & FORMAT(([Column1] - INT([Column1])) * 60,"00") & ":00"
@anlu20 Maybe:
Column = FORMAT(INT([Column1]),"00") & ":" & FORMAT(([Column1] - INT([Column1])) * 60,"00") & ":00"
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |