Power query strips decimals when importing decimal date

[brownricefrog]

Hi,

I have an .xls data source with decimal datetime data eg: 44834.3877777778 and I want it to show it as 30/09/2022 09:18:24

But when I import into power query the decimals are already gone. I change Date/Time and it gives 30/09/2022 00:00:00

Where did the HH:MM:SS go? What am I doing wrong? How do I get the decimals back?

The worst part is that when I started working on this a couple of hours ago it was giving date and time as expected, and then all of a sudden started stripping the time out and I don't know why. Getting really frustrated over here, any tips or tricks appreciated.

[brownricefrog · Accepted solution]

Oh my wow. I got into work this morning and it's working now.

I started from scratch on the job, slightly different approach, but basically the same thing. All the times are there now. Huh. The universe must have it in for me this week.

[HotChilli]

can you post the 'Advanced Editor' code please?