Forum Discussion

shantupm5's avatar
shantupm5
Helper III
3 years ago

Time format

Hello,   I have a time format in data set to which is avg of turn around time. Which is also >24 hrs. How can i format it to >24 hrs, which is available in MS Excel (37:30:55) I dont see similar ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi shantupm5 ,

 

It doesn't exist over 24 hours of time format in Power Query.

Well, you could change the type as text format.

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • shantupm5's avatar
    shantupm5
    Helper III
    3 years ago

    Hi Stephen,

    I need to performe other calculations basis the result i get. but i suppose we cant write measures on text format.

     

    Advice

    Prashanth