Decimal to Datetime conversion

I have an excel file where there are columns in date-time format like below -

Response time

28-02-2022 10:53:22

28-02-2022 11:34:13

When I try to import the file in Alteryx, it's showing in decimal values like below -

How can I fix that?

Accepted answers

Here is how you can do it. The best way is to use the multi-field formula tool and ToDateTime() function.

Workflow:

Hope this helps : )

Here is the updated workflow

Hope this helps : )

@EN6924 you can convert them in to date format using the bellow formula

DateTimeAdd('1900-01-01',toNumber([Call Open Date]) -2, "days")

You can use a multi-field formula and a todatetime() function to fix this:

Here is how you can do it. The best way is to use the multi-field formula tool and ToDateTime() function.

Workflow:

Hope this helps : )

hey @EN6924

Can you please upload an isolated part of your excel spreadsheet?

Thanks,
TheOC

It's still not working

oh, Xls file format its an old and doesn't support a lot of features. Let me look into it 😅

@EN6924 you can convert them in to date format using the bellow formula

DateTimeAdd('1900-01-01',toNumber([Call Open Date]) -2, "days")