Forum Discussion
Excel to power query clock/time issue
Hi saad_mce,
I think you will need to add a conditional column that if time is greater than 23:59:59 then add 1 to the Finish Date.
Ideally, 24:00:00 is equivilant to 00:00:00, which is when the next day begins.
You can also try converting the time into a numeric value by multiplying it by 24*60*60 = 86,400 and then adding the conditional column.
I think PQ works faster on numbers than any other data type.
Hope this helps.
Thank you,
Vishesh Jain
Hi saad_mce ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
Hi Stephen,
Apologies for late response.
I work on powerbi reports on a monthly basis. I did not have a chance to come back to this report earlier.
The conditional column solution suggested by visheshjain worked better.
Regards,
Abrar