Forum Discussion
Solved
Excel to power query clock/time issue
Hi all, I have below data in excel. This is the start and end time of a production order in SAP. Schedule Start Start Time Schedule Finish Finish Time 10.01.2022 22:05:35 10.01.2022 24:...
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