Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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
Free Trial

Alteryx Designer Desktop Discussions

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

Converting Time to a number

Otisdaddy
5 - Atom
‎03-12-2021 08:14 AM

I have a file which contains the open and close activity for a store over multiple days.  What I am trying to do is to provide an average opening and closing time for the store.  What I need to do is convert the time column to a numerical field and then summarize on that field.  For example, in Excel converting 7:30 AM to numeric results in 0.31.  That is exactly what I am trying to do in Alteryx.  Any help?

Labels:
Reply
0 Likes
2 REPLIES 2
Luke_C
17 - Castor
17 - Castor
‎03-12-2021 08:21 AM

@Otisdaddy 

 

This thread has a solution that should work for your use case:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-the-average-of-the-time/td...

 

Reply
0 Likes
messi007
15 - Aurora
15 - Aurora
‎03-12-2021 08:26 AM

@Otisdaddy,

 

Please take a look on this post: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Calculating-the-average-of-the-time/td... 

 

it's doing exactly what you're asking for.

 

Hope this helps,

Regards,

Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All