Power Query Importing 24hr dates incorrectly

[rdorsey]

I have a sharepoint list with "Start" and "End" fields. These are standard date and time fields displayed in 24hr time format. When I import these columns to Power BI with the SharePoint Online List connector it changes the time to 12hr time, but it's the wrong value. I can't figure out what it's doing or what I'm doing wrong, but this is obviously a serious issue for my reporting. A few examples are below:

Sharepoint	Power Query
15:00	8:00PM
12:00	5:00PM
21:48	2:48AM
10:30	3:30PM
14:14	7:14PM

[Vijay_A_Verma · Accepted solution]

This is due to time zone. Your all times are off by +5 hours. After import, you can put following formula to convert back to right time (Replace Time Column appropriately)

= [Time Column]-#duration(0,5,0,0)