Convert standard date and time 24hrs

[Anonymous]

Good afternoon.

I need to convert a base that is connected to a sharepoint list with columns of start date, start time, end date, end time, all columns are as string and the biggest problem is as 24Hrs, that is, midnight time in base shows up as 24:00 and not 00:00.

[v-eqin-msft]

Hi @Anonymous ,

As you mentioned——columns of start date, start time, end date, end time, all columns are as string 

So please go to Power Query dialog and transform the columns to the correct types firstly.

Then you could choose the dispaly format as @amitchandak said.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , if this datetime field, You should be able to choose a format to display