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,
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