Converting Time to a number

Question

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?

messi007 · Answer

@Otisdaddy,

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

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

Hope this helps,

Regards,

Luke_C · Answer

@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-p/662671