Forum Discussion
Solved
Format text to time format
Hi, I am using the following formula to calculate the duration that operators spent on IT tickets: ------------------------------------------------------------- TijdBesteed = VAR TotalTime = IF...
Hi thank you. I have found another solution, where i convert seconds to time duration using the query editor. Found the answer on this page: https://community.fabric.microsoft.com/t5/Desktop/How-to-convert-seconds-to-hh-mm-ss/m-p/310816#M137682
currently the output is Text. you need to use date or time function to make the output be datetime type.
Hi thank you. I have found another solution, where i convert seconds to time duration using the query editor. Found the answer on this page: https://community.fabric.microsoft.com/t5/Desktop/How-to-convert-seconds-to-hh-mm-ss/m-p/310816#M137682