Forum Discussion

saad_mce's avatar
saad_mce
Helper I
4 years ago
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:...
Need Help
  • visheshjain's avatar
    visheshjain
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi saad_mce ,

 

The first method is to change the data type of the time column to text.

 

The second method is that if you mainly want the report to show 24-hour time, you can also use the h:nn:ss format to change the format of the time column after loading into Power BI.

 

 

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.