We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert time to decimals

dkma
8 - Asteroid
‎06-25-2021 03:33 PM

Hello, I'm new to Alteryx,

 

Can Any one help me on converting time format to Decimals format.

 

Like 2h:45m to 2.75

Labels:
Reply
0 Likes
5 REPLIES 5
Emil_Kos
17 - Castor
17 - Castor
‎06-25-2021 03:43 PM

Hi @dkma,

 

I have a solution ready for you:

 

Emil_Kos_0-1624660991156.png

 

Date parse.yxmd
Reply
0 Likes
dkma
8 - Asteroid
‎06-25-2021 04:00 PM

Sorry for bothering

 

 

 

How to convert 13:15:00  to 13.25

Reply
0 Likes
dkma
8 - Asteroid
‎06-25-2021 04:04 PM

Sorry for bothering

 

How to convert 13:15:00  to 13.25

Reply
0 Likes
Emil_Kos
17 - Castor
17 - Castor
‎06-25-2021 04:06 PM

Hi @dkma,

 

No worries I am happy to help!

 

It should work for both of your examples. 

 

Emil_Kos_0-1624662343959.png

 

Date parse.v2yxmd.yxmd
Reply
0 Likes
ArtApa
Alteryx
Alteryx
‎06-25-2021 08:10 PM

In order to offer the best solution it would be great to see all data variations first.

Reply
0 Likes
Live Office Hours
Labels
Top Solution Authors
View All