Forum Discussion
24:00:00 Records Changing Type to Duration
Hi guys, how is everything? I’ve a power query table with many columns that got type of “any” at the beginning, many of these columns got records of 24:00:00, when I change the type of the mentio...
Hi Anonymous ,
See this post, he solved his problem by converting the column from text to time and replacing value error to 11:59:59 p.m.
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.